Home > database >  Oracle data remote export and import
Oracle data remote export and import

Time:09-22

1, the shortcut key win + R, type CMD, [open a console]

2, the importation of import and export order

Export orders: [enter commands - & gt; u - & gt; yes, & gt; yes, & gt; yes]

Exp database login name/password @ remote database host computer IP: 1521/SID file=d: \ export the file name. DMP full=y

Such as: exp Scott/[email protected]:1521/former file=d: \ demo_data DMP full=y

Export orders

Imp database login name/password @ remote database host computer IP: 1521/SID file=d: \ import file name. DMP full=y

Such as: imp Scott/[email protected]:1521/former file=d: \ demo_data DMP full=y

Note:

1521: Oracle port SID: Oracle installation process, setting the global variable problem import process, garbled words, reason: the source file library is different from the file object library character set

CodePudding user response:

Record in a blog post, post maybe which day will be gone,
  • Related