Impdp experience ORA-39001, ORA-39000, ORA-39142, impdpora-39001

Source: Internet
Author: User

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 ~] $

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.