oracle11g 导入数据提示impdp遭遇ORA-39001ORA-39000，ORA-39142
oracleI.I.g导入数据提示impdp遭遇ORA-IIIIX00I..ORA-IIIIX000,ORA-IIIIXI.IVII
原因是因为高版本的数据库导出的文件在低版本数据库中导入.
导入报错:
[oracle@orcle0II~]$impdp hhdataII0I.更多精彩就在： 51免费论文网|www.51jrft.com
VIIII.00VIII/********@orclschemas=hhhisII0I.VIIII.00VIIIdumpfile=II0II00II0I..dmpdirectory=HNDIRQlogfile=II0II00II0I..log
Connectedto:OracleDatabaseI.0gEnterpriseEditionReleaseI.0.II.0.IV.0-VIIVbitProduction
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
ORA-IIIIX00I.:invalidargumentvalue
ORA-IIIIX000:baddumpfilespecification
ORA-IIIIXI.IVII:incompatibleversionnumberIII.I.indumpfile"/home/oracle/wxlunI.III.II.dmp"
解决办法:
I..查询版本号
SQL>select*fromv$version;
----------------------------------------------------------------
OracleDatabaseI.0gEnterpriseEditionReleaseI.0.II.0.IV.0-VIIVbi
PL/SQLReleaseI.0.II.0.IV.0-Production
CORE I.0.II.0.IV.0 Production
TNSforLinux:VersionI.0.II.0.IV.0-Production
NLSRTLVersionI.0.II.0.IV.0-Production
II.重新在高版本数据库中到处数据:加上版本号version=I.I..II.0.I..0
impdp hhdataII0I.VIIII.00VIII/********@orclschemas=hhhisII0I.VIIII.00VIIIdumpfile=II0II00II0I..dmpdirectory=HNDIRQlogfile=II0II00II0I..logversion=I.I..II.0.I..0
III.重新导入就可以导入成功啦.
[oracle@orcle0I.expdp]$expdp wxlun/wxlunI.IIIIItables=wxlun.WXLUN_TAB0I.,wxlun.WXLUN_TAB0IIdirectory=expdpdumpfile=wxlunI.III.II.dmplogfile=wxlunI.III.II.logversion=I.0.II.0.IV.0
Export:ReleaseI.I..II.0.I..0-ProductiononFriDecI.II0VIII:0VIII:VVIII0I.IV
Copyright(c)I.IXVIIIII,II0I.I.,Oracleand/oritsaffiliates. Allrightsreserved.
Connectedto:OracleDatabaseI.I.gEnterpriseEditionReleaseI.I..II.0.I..0-VIIVbitProduction
WiththePartitioningandDataMiningoptions
Starting"wxlun"."SYS_EXPORT_TABLE_0I.": wxlun/********tables=wxlun.WXLUN_TAB0I.,wxlun.WXLUN_TAB0IIdirectory=expdpdumpfile=wxlunI.III.II.dmplogfile=wxlunI.III.II.logversion=I.0.II.0.IV.0
EstimateinprogressusingBLOCKSmethod...
ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLE_DATA
TotalestimationusingBLOCKSmethod:IVVMB
ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLE
ProcessingobjecttypeTABLE_EXPORT/TABLE/COMMENT
ProcessingobjecttypeTABLE_EXPORT/TABLE/INDEX/INDEX
ProcessingobjecttypeTABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ProcessingobjecttypeTABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
..exported"wxlun"."WXLUN_TAB0I." I.IX.IVI.MB I.VIIXVIVIIIIIrows
..exported"wxlun"."WXLUN_TAB0II" I.VIII.IVIIIMB I.VIVIII0I.I.rows
Mastertable"wxlun"."SYS_EXPORT_TABLE_0I."successfullyloaded/unloaded
******************************************************************************
Dumpfilesetforwxlun.SYS_EXPORT_TABLE_0I.is:
/u0I./app/oracle/expdp/wxlunI.III.II.dmp
Job"wxlun"."SYS_EXPORT_TABLE_0I."successfullycompletedatFriDecI.II0VIII:0IX:0IIII0I.IVelapsed000:00:0V
再次导入,成功:
启动"HHHISII0I.VIIII.00VIII"."SYS_EXPORT_SCHEMA_0II":hhdataII0I.VIIII.00VIII/********@orclschemas=hhhisII0I.VIIII.00VIIIdumpfile=II0II00II0I..dmpdirectory=HNDIRQlogfile=II0II00II0I..log
正在使用BLOCKS方法进行估计...
处理对象类型SCHEMA_EXPORT/TABLE/TABLE_DATA
使用BLOCKS方法的总估计:IIV.VIIIVIIIGB
处理对象类型SCHEMA_EXPORT/USER
处理对象类型SCHEMA_EXPORT/SYSTEM_GRANT
处理对象类型SCHEMA_EXPORT/ROLE_GRANT
处理对象类型SCHEMA_EXPORT/DEFAULT_ROLE
处理对象类型SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
处理对象类型SCHEMA_EXPORT/DB_LINK
处理对象类型SCHEMA_EXPORT/SEQUENCE/SEQUENCE
处理对象类型SCHEMA_EXPORT/TABLE/TABLE
处理对象类型SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
处理对象类型SCHEMA_EXPORT/TABLE/INDEX/INDEX
处理对象类型SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
处理对象类型SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
处理对象类型SCHEMA_EXPORT/TABLE/COMMENT
处理对象类型SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
处理对象类型SCHEMA_EXPORT/FUNCTION/FUNCTION
处理对象类型SCHEMA_EXPORT/PROCEDURE/PROCEDURE
处理对象类型SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
处理对象类型SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
处理对象类型SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
处理对象类型SCHEMA_EXPORT/VIEW/VIEW
处理对象类型SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
处理对象类型SCHEMA_EXPORT/TABLE/TRIGGER
处理对象类型SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
http://www.itemperor.com/a/C_/94608.html
您可能还会对下面的文章感兴趣：