In this case, I was told a "datapump" export file was provided. However, when I performed the datapump import, it failed with ORA-39000. From my best knowledge
only couple things could trigger this error. There are either corrupted datapump import file or user performed an import with "imp" instead of datapump. Datapump file
corruption usually resulted of zip being trimmed during ftp or uploading.
Importing with "impdp" will trigger the following error.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file "/backup/RD_20140217-2.dmp" may be an original export dump file
imp RDU file=/home/oracle/downloads/CHGPR_20140217.dmp full=n buffer=2000000 commit=y ignore=y log=/home/oracle/downloads/imp_RDU_20140217.log
No comments:
Post a Comment