Home » RDBMS Server » Server Utilities » ORA 39000 | ORA 39142 (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)
ORA 39000 | ORA 39142 [message #677747] Fri, 11 October 2019 00:57 Go to previous message
vippysharma
Messages: 73
Registered: May 2013
Location: www
Member
I have dump file exported (using expdp) from oracle DB (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) and while importing the same dump file in new DB in separate m/c (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) using impdp, getting Ora-39000 & Ora-39142 error. (bad dump file | Incompatible version)
Attached is the Dump file info screenshot (Dump_info.jpg) using show_dump_file_info proc...

Both the source and target database is having same version and not sure why i am getting this error. Analysis said to do fresh export using VERSION parameter. Is there any other way to import without re-executing export?

  • Attachment: Dump_Info.JPG
    (Size: 28.65KB, Downloaded 2542 times)
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: oracle solution for sqoop
Next Topic: Schema export with parallel parameter
Goto Forum:
  


Current Time: Thu Mar 28 19:26:44 CDT 2024