一个简单的导入,报错:
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
阅读(1120) | 评论(0) | 转发(0) |