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!

ORA-39000 Bad dump file specification

939393May 9 2012 — edited May 10 2012

Hi All Guru's,

I am facing problem while exporting a dump file from one server where OS is Solaris 10 is running and Oracle DB Version is 10.2.0.2.0 and try to import it to other server where OS is Windows Server 2003 and DB Version is 10.2.0.1.0

With the below script

for export:

expdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log version=10.2.0.1.0

and for import:

impdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=impdpEMP_DEPT.log

but during import i am getting below error:

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "I:\bscsprod.dmp"

can anyone tell me where i am mistaking

thanks in advance

Edited by: Vikas Kohli on May 9, 2012 5:16 PM