To connect to: Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options
ORA - 39001: invalid parameter value
ORA - 39000: dump file specification error
ORA - 31640: unable to open to read the dump file "E: \ app \ TGDB \ xir_trd_exh DMP"
ORA - 27041: unable to open file
OSD - 04002:?????????
O/S - Error: 2 (OS)??????????????????????????

Statement execution is
The create or replace directory impdp_dir as' E: \ app \ TGDB ';

Grant read, write on directory impdp_dir to xir_app, xir_md, xir_trd, xir_trd_exh;
Echo
Impdp xir_app/xpar @ former directory=impdp_dir dumpfile=impdp_dir: xir_app. DMP logfile=impdp_dir: DstDate xir_app_ % % _in. The log table_exists_action=skip exclude=statistics


Also use expdp export export, export of oracle versions and import, don't know where is wrong, please comment

CodePudding user response:

Dumpfile=impdp_dir: xir_app. DMP? Shouldn't dumpfile=xir_app. DMP? Would you write to read less than DMP so error!

CodePudding user response:

Confirm file exists, the path is correct, the file content is legal,

PS: can be written as dumpfile=dmp_dir: XXXX. The form of DMP,

CodePudding user response:

Backup and restore import and export

http://www.verejava.com/? Id=17173807122159

CodePudding user response:

reference 1st floor qq_34182425 response:

dumpfile=impdp_dir: xir_app. DMP? Shouldn't dumpfile=xir_app. DMP? Would you write that couldn't read DMP so error,

Impdp_dir is write a configuration script, write that there is no problem

CodePudding user response:

Pay a imp_full_database try view the authority

CodePudding user response:

reference 5 floor baidu_36457652 reply:

view permissions to pay under a imp_full_database try

Wrong, wrong, is to look at your file permissions on the path, oracle, and user permissions on this directory