I am running data import via impdp tool. Most objects imported successfully but some gave me error ORA-39082 Object type created with compilation warnings. I did some reasearch and looks liek the issue scan be fixed by running utlrp.sql script to recompile all invalid objects. I have never ...
备注: 还原时impdp.log文件中出现以下ORA-编号开头的信息是正常的,可以忽略。 ORA-31684: 对象类型 USER:"XXX" 已存在 ORA-39082: 对象类型 XXX 已创建, 但带有编译警告 ORA-39126: 在 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] 中 Worker 发生意外致命错误 (这是最后导入统计信息出错,可以忽略)...
1、impdp报ORA-39082 导入过程中报错 代码语言:javascript 复制 ORA-39082: Object type PACKAGE_BODY:"XXXX"."PXG_TS_LEAING" created with compilation warnings 通过以下SQL查询到状态为INVALID,忽略 代码语言:javascript 复制 select owner,object_name,object_type,status from dba_objects where object_name='PX...
-rw-r--r-- 1 oracle oinstall 38991 Jun 2 20:27 /data1/zj_regular.log IMP导入花费了3小时17分钟,下面看看IMPDP导入的速度: $ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.3.0 - Production on 星期六 6月 2 21:08:43 2007 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. 连...
6 开始传输oracle@odd-LINFAN ~]$ impdp system directory=data_pump_dir dumpfile=tts_rcat.dmp logfile=cs_import.log transport_datafiles=/u01/app/oracle/oradata/POTATO/rcat.dbfImport: Release 11.2.0.3.0 - Production on Thu Feb 23 16:38:52 2017Copyright (c) 1982, 2011, Oracle and/or...
impdp sde/esri@pdbsde schemas=sde directory=sdedmp dumpfile =expdp_sde1.dmp logfile=impdp_sde1.log (4)错误信息记录 导入时的错误信息如下: ORA-39082: 对象类型 TYPE_BODY:"SDE"."ST_GEOMETRY" 已创建, 但带有编译警告 ORA-39082: 对象类型 TYPE_BODY:"SDE"."ST_GEOMETRY" 已创建, 但带有编译警告...
impdp system/Test6530 directory=dir schemas=lcor199999 dumpfile=OR19WithPatch20190520ver11204.dmp logfile=20190521 1. 4. 但是存在了几个错误: 处理对象类型 SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE ORA-39082: 对象类型 ALTER_PROCEDURE:"LCOR199999"."ERP_ZJDICT_DICTFINDRECORD"已创建, 但带有编译警告 ...
二、exp/imp与expdp/impdp区别 (1) 把用户usera的对象导到用户userb,用法区别在于fromuser=usera touser=userb ,remap_schema=’usera’:'usera’ 。 例如:imp system/passwd fromuser=usera touser=userb file=/oracle/exp.dmp log=/oracle/exp.log; ...
impdp jingyu/jingyu directory=jy dumpfile=jingyu.dmpREMAP_SCHEMA=jingyu:jingyu2 实际执行导入的输出如下: 代码语言:javascript 复制 [oracle@jyrac1 orabak]$ impdp jingyu/jingyu directory=jy dumpfile=jingyu.dmpREMAP_SCHEMA=jingyu:jingyu2Import:Release11.2.0.4.0-Production on Thu Jun817:11:212017Copyrig...
impdp \'/ as sysdba\' directory=EXPDP_DATA dumpfile=qpasdwsx_%U.dmp parallel=4 logfile=impdp_qp.log content=metadata_only AI代码助手复制代码 修改字段 因为字符集不同字段宽度不够,需要提前测试 altertableCONFIG.CFG_CN_CHAR_DICT modifyvalueCHAR(3);altertableDATA_HANYU_CORE_BASE.HANZI modify HANZI...