My Oracle Support Banner

How To Solve Error: ORA-39143 (Doc ID 1288715.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Communications Order and Service Management - Version 7.0.1 to 7.0.1 [Release 7.0.0]
Oracle Database - Enterprise Edition - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.
Aug 15, 2012 Review relevance
Jan 15, 2015 Review relevance
July 6, 2016 Review relevance
Nov 8, 2017 Review relevance


When trying to import OSM schema dump file using this command -

impdp osm702_whp/osm702_whp DIRECTORY=OSM_IMP_EXP dumpfile=osm4.dmp full=y

Received the following errors:

Connected to: Oracle Database 11g Enterprise Edition Release - 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 "C:\temp\oracle_imp_exp_pump\osm4.dmp" may be an original export dump file


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.