ORA-39142: incompatible version number 5.1

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@racj1 linshidmp]$ impdp \'/ as sysdba\' directory=linshidmp remap_schema=GEJ:TELECOM dumpfile=exp_ofeer2.dmp logfile=OFFER_PROD.log  cluster=n parallel=1 tables=GEJ.OFFER_PROD_2_SA_2_COMPONENT

Import: Release 11.2.0.4.0 - Production on Thu Aug 15 20:05:58 2019

Copyright (c) 1982, 2011, 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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 5.1 in dump file "/bak/linshidmp/exp_ofeer2.dmp"

 

源端导出加上参数重新导出即可：

导出加上参数version=11.2.0.4.0

expdp \'/ as sysdba\' directory=dmp schemas=jyc version=11.2.0.4.0 dumpfile=jyc-`date  "+%Y%m%d_%H%M%S"`.dmp  logfile=jyc-`date  "+%Y%m%d_%H%M%S"`.log EXCLUDE=TABLE:\"IN \(\'EE_SCENE_ORDER_LOG\'\)\" exclude=TABLE:\"LIKE\'EE_SCENE_ORDER_AUTO_%\'\"  exclude=statistics

[oracle@racj1 linshidmp]$ impdp \'/ as sysdba\' directory=linshidmp remap_schema=GEJ:TELECOM dumpfile=exp_ofeer2_2.dmp logfile=OFFER_PROD.log  cluster=n parallel=1 tables=GEJ.OFFER_PROD_2_SA_2_COMPONENT

Import: Release 11.2.0.4.0 - Production on Thu Aug 15 20:22:17 2019

Copyright (c) 1982, 2011, 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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLE_01":  "/******** AS SYSDBA" directory=linshidmp remap_schema=GEJ:TELECOM dumpfile=exp_ofeer2_2.dmp logfile=OFFER_PROD.log cluster=n parallel=1 tables=GEJ.OFFER_PROD_2_SA_2_COMPONENT 
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"TELECOM"."OFFER_PROD_2_SA_2_COMPONENT" failed to create with error:
ORA-00959: tablespace 'DATA' does not exist
Failing sql is:
CREATE TABLE "TELECOM"."OFFER_PROD_2_SA_2_COMPONENT" ("PROD_ID" NUMBER(12,0) NOT NULL ENABLE, "SERVICE_ID" NUMBER(12,0) NOT NULL ENABLE, "ACC_NUM" VARCHAR2(32 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"TELECOM"."OFFER_PROD_2_SA_2_COMPONENT" creation failed
Job "SYS"."SYS_IMPORT_TABLE_01" completed with 2 error(s) at Thu Aug 15 20:22:23 2019 elapsed 0 00:00:05

[oracle@racj1 linshidmp]$ impdp \'/ as sysdba\' directory=linshidmp remap_schema=GEJ:TELECOM dumpfile=exp_ofeer2_2.dmp logfile=OFFER_PROD.log  cluster=n parallel=1 tables=GEJ.OFFER_PROD_2_SA_2_COMPONENT REMAP_TABLESPACE=DATA:USERS

Import: Release 11.2.0.4.0 - Production on Thu Aug 15 20:23:11 2019

Copyright (c) 1982, 2011, 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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLE_01":  "/******** AS SYSDBA" directory=linshidmp remap_schema=GEJ:TELECOM dumpfile=exp_ofeer2_2.dmp logfile=OFFER_PROD.log cluster=n parallel=1 tables=GEJ.OFFER_PROD_2_SA_2_COMPONENT REMAP_TABLESPACE=DATA:USERS 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "TELECOM"."OFFER_PROD_2_SA_2_COMPONENT"     30.89 MB 1105857 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYS"."SYS_IMPORT_TABLE_01" successfully completed at Thu Aug 15 20:23:19 2019 elapsed 0 00:00:06