Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP Error (ORA-39000/ORA-31640/ORA-27041)

603447Sep 12 2009 — edited Sep 13 2009

Need help on this. I have done the following steps.

1. Create DATAEXP directory and assign priviledge under SYSTEM:
CREATE DIRECTORY DATAEXP AS 'Z:\DBDump';

GRANT READ, WRITE ON DIRECTORY DATAEXP TO PUBLIC;

2. Create batch file and execute:

set oracle_sid=orcl
impdp system/system full=y DIRECTORY=DATAEXP PARALLEL=24 dumpfile=exp_200909041849_%U.dmp logfile=imp_20090912.log

3. Error message appears

;;;
Import: Release 10.2.0.3.0 - Production on Saturday, 12 September, 2009 17:57:49

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "Z:\DBDump\exp_200909041849_U.dmp" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

4.Have 4 dump files on Z:\DBDump

exp_200909041849_01.dmp
exp_200909041849_02.dmp
exp_200909041849_03.dmp
exp_200909041849_04.dmp