Home > database >  Oracle expdp impdp confusion
Oracle expdp impdp confusion

Time:10-13

This can only be used on the server, and this I see,
- create a logical path
Create the directory EXPNC_DIR as' D: \ app \ oracletablespace ';

- expdp operation on the command line
CMD - & gt; [export grammar]


Expdp system/manager DIRECTORY=EXPNC_DIR DUMPFILE=full. DMP full=y

This I also see
Is to create a path, and then the export DIRECTORY=EXPNC_DIR equal path name, performed to determine OK,



But but but

import?Impdp system/manager DIRECTORY=dump_dir DUMPFILE=full. DMP full=y;

"DIRECTORY=dump_dir" where is this??
I need to create a path?? Create the directory dump_dir as' D: \ app \ daoru '; ??
DUMPFILE=full. This is how to locate the DMP,,

CodePudding user response:

I top once, see how great god resides not

CodePudding user response:

"DIRECTORY=dump_dir" where is this??


Export and import on the same server, use the same DIRECTORY,

CodePudding user response:

refer to the second floor selling fruit net reply:
"DIRECTORY=dump_dir" where is this??


Export and import on the same server, use the same DIRECTORY,

The see,

If it is not the same server, it will need to create the DIRECTORY on the new server, and then put full. DMP file into the folder, import?

CodePudding user response:

reference ni04730184 reply: 3/f
Quote: refer to the second floor selling fruit net reply:
"DIRECTORY=dump_dir" where is this??


Export and import on the same server, use the same DIRECTORY,

The see,

If it is not the same server, it will need to create the DIRECTORY on the new server, and then put full. DMP file into the folder, import?


Right, if is a Linux system, pay attention to the permissions,

CodePudding user response:

You need to create the directory object, can't use the path to access the data pump, go through the directory object access
  • Related