ORA-39083&ORA-02304

问题描述

使用数据泵在Oracle11.2.0.4中导入提示如下报错：

导入命令：
nohup impdp TOPICIS/topicis directory=DATA_PUMP_DIR dumpfile=20241107_topicis2024.dmp logfile=20241107_topicis2024_imp.log   remap_schema=TOPICIS2024:topicis  parallel=8 &
输出如下报错：
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "TOPICIS"."TAB_LOCKINFO"   OID '1B138976C0E77DA3E063E29213AC6CBA' AS TABLE of ARR_LockInfo 
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE

分析过程

type无法创建成功，原因是OID重复，OID就是object id。

查看impdp帮助命令：impdp help=y 发现：

impdp中有个transform参数，该参数默认是Y，如果改成N，那么导入的时候会把各个对象重新赋予新的OID。

解决办法

在导入命令中增加transform=oid:n

nohup impdp TOPICIS/topicis directory=DATA_PUMP_DIR dumpfile=20241107_topicis2024.dmp logfile=20241107_topicis2024_imp.log   remap_schema=TOPICIS2024:topicis transform=oid:n parallel=8 &

再用impdp导入的时候就不会出现如下报错：

ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal