一个简单的导入,报错:
CREATE TYPE "test_user"."type1" OID '5BED7664FB75646FE0536E2B010A0B4C' IS table of qrtable1
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "test_user"."T_A_TABLE" OID '4BEE46F622FE2375E0536E2B010A51C0' is table of gtable1;
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "test_user"."T_Q_TABLE" OID '3BEE46FE1DD4245BE0536E2B010A1E42' is table of tt_market_table;
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
oid捣乱
[host1:oracle]:/oradata>impdp user1/user123 DIRECTORY=EXP_DIR
DUMPFILE=expd_20201214.dmp logfile=imp_1218.log schemas=zhcx
REMAP_SCHEMA=zhcx:zhcx_test table_exists_action=replace
transform=segment_attributes:n,oid:n
正常导入。
参考:
https://blog.csdn.net/chengzhezhijian/article/details/32705929
阅读(1225) | 评论(0) | 转发(0) |