Linux ORA-39001, ORA-39142 Solution

Linux, the machine is Oracle 11g Database, import database for 10g, through expdp, impdp Data Pump import, at the beginning of the prompt ora-39001, found that the file directory is not found or the file name is not the same.

According to the prompt, the version of the dump file is incorrect. Check whether the current library is located.

SQL> show parameter compatible

 

NAME TYPE VALUE

-----------------------------------------------------------------------------

Compatible string 11.1.0.6

Import to the database

SQL> show parameter compatible;

 

NAME TYPE VALUE

-----------------------------------------------------------------------------

Compatible string 10.2.0.1.0

 

Solution:

Use the version parameter to re-export the table

[Oracle @ testdb ~] $ Expdp justin/*** directory = pump dumpfile = justin_tab.dmp tables = justin_tab version = 10.2.0.1.0

Continue to import the generated database

[Oracle @ rac1 ~] $ Impdp justin/*** directory = pump dumpfile = justin_tab.dmp version = 10.2.0.1.0

Imported

SPFILE error causing database startup failure (ORA-01565)

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods