一、报错现象
ORA-39083: Object type TYPE:"MESPRD"."STRSPLIT_TYPE" failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE EDITIONABLE TYPE "MESPRD"."STRSPLIT_TYPE" OID '8CD681DD4A3713BEE053D30112AC8456' IS TABLE OF VARCHAR2 (4000)
二、分析原因：
原来在Oracle中，每一个type都会分配出唯一的oid编号
解决方法导入时加入 transform=oid:n （将旧的id映射成新的）
impdp esttest/reinspection1234@web_192.168.200.10 directory=dump_esttest dumpfile=dumpscott.dmp logfile=exp.log remap_schema=esttest:tdd21 transform=oid:n
impdp mesprd/Mes1qaz#EDC dumpfile=SHYCBZMESQAS-20200407.dmpdp logfile=SHYCBZMESQAS-20200407_imp.log DIRECTORY=backup_mes REMAP_SCHEMA=MESSHYCBZ:MESPRD schemas=MESSHYCBZ transform=oid:n
文章评论