Oracle Database Discussions

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!

datapump error

newbiegalOct 1 2010 — edited Oct 2 2010

Hi friends,

I'm importing a database from a datapump export(below are the first few lines from the export log file).

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
Starting "USER1"."SYS_EXPORT_SCHEMA": 'USER1/********@TEST' PARFILE='Exp%U.dat'
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 53.11 GB
Processing object type SCHEMA_EXPORT/USER
......

There are multiple Export dump files such as exp01.dmp, exp02.dmp ... exp15.dmp. I get the below error when I import..

C:> impdp system/pwd@db1 directory=datapump_dir dumpfile=exp%u.dmp logfile=imp.log full=n schemas= spg,kas

Import: Release 10.2.0.4.0 - 64bit Production on Friday, 01 October, 2010 11:21:12

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file "c:\data\exp01.dmp" may be an original export dump

Any suggestions please?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2010

Added on Oct 1 2010

#general-database-discussions

4 comments

691 views