Impdp experience ORA-39001, ORA-39000, ORA-39142, impdpora-39001
Expdp/impdp because the source data version is higher than the target database version, encounter ORA-39001, ORA-39000, ORA-39142, solve only need to expdp export with the target data version, the specific problem and solution is as follows:
Import error:
[Oracle @ orcle02 ~] $ Impdp scott/tiger directory = expdp dumpfile = wxlun1212.dmp logfile = wxlun1212.log remap_schema = wxlun: scott REMAP_TABLESPACE = wxlun: USERS
Import: Release 10.2.0.4.0-64bit Production on Friday, 12 December, 2014 8:06:09
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.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-39142: incompatible version number 3.1 in dump file "/home/oracle/wxlun1212.dmp"
Target database version:
[Oracle @ orcle02 ~] $ Sqlplus/as sysdba
SQL * Plus: Release 10.2.0.4.0-Production on Fri Dec 12 08:07:11 2014
Copyright (c) 1982,200 7, Oracle. All Rights Reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v $ version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bi
PL/SQL Release 10.2.0.4.0-Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0-Production
NLSRTL Version 10.2.0.4.0-Production
SQL>
Source database version:
[Oracle @ orcle01 expdp] $ sqlplus/as sysdba
SQL * Plus: Release 11.2.0.4.0 Production on Thu Dec 11 20:05:46 2014
Copyright (c) 1982,201 3, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning and Data Mining options
SQL> select * from v $ version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
PL/SQL Release 11.2.0.4.0-Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0-Production
NLSRTL Version 11.2.0.4.0-Production
SQL> exit
The source database version is 11.2.0.4.0 and the target database version is 10.2.0.4.0. The source database version is later than the target database version. When the source database exports data, add the target version:
[Oracle @ orcle01 expdp] $ expdp wxlun/wxlun123 tables = wxlun. WXLUN_TAB01, wxlun. WXLUN_TAB02 directory = expdp dumpfile = wxlun1212.dmp logfile = hosts = 10.2.0.4.0
Export: Release 11.2.0.4.0-Production on Fri Dec 12 08:08:56 2014
Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning and Data Mining options
Starting "wxlun". "rolling": wxlun/******** tables = wxlun. Routing, wxlun. Export directory = expdp dumpfile = wxlun1212.dmp logfile = wxlun1212.log version = 10.2.0.4.0
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 45 MB
Processing object type TABLE_EXPORT/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
.. Exported "wxlun". "WXLUN_TAB01" 19.41 MB 169682 rows
.. Exported "wxlun". "WXLUN_TAB02" 18.43 MB 168011 rows
Master table "wxlun". "SYS_EXPORT_TABLE_01" successfully loaded/unloaded
**************************************** **************************************
Dump file set for wxlun. SYS_EXPORT_TABLE_01 is:
/U01/app/oracle/expdp/wxlun1212.dmp
Job "wxlun". "SYS_EXPORT_TABLE_01" successfully completed at Fri Dec 12 08:09:02 2014 elapsed 0 00:00:05
Import again. Successful:
[Oracle @ orcle02 ~] $ Impdp scott/tiger directory = expdp dumpfile = wxlun1212.dmp logfile = wxlun1212.log remap_schema = wxlun: scott REMAP_TABLESPACE = wxlun: USERS
Import: Release 10.2.0.4.0-64bit Production on Friday, 12 December, 2014 8:09:36
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SCOTT". "SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SCOTT". "example": scott/******* directory = expdp dumpfile = wxlun1212.dmp logfile = wxlun1212.log remap_schema = wxlun: scott REMAP_TABLESPACE = wxlun: USERS
Processing object type TABLE_EXPORT/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
.. Imported "SCOTT". "WXLUN_TAB01" 19.41 MB 169682 rows
.. Imported "SCOTT". "WXLUN_TAB02" 18.43 MB 168011 rows
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SCOTT". "SYS_IMPORT_FULL_01" successfully completed at 08:10:54
[Oracle @ orcle02 ~] $