环境：oracle 9.2.0.1导入； 从9.2.0.4库上导出（导出客户端是9.2.0.1）；
同义词带dblink,且table_owner为空的imp时报错，发现少部分能正常导入；与dblink是否有效无关；
解决办法，手工创建同义词：
IMP-00017: following statement failed with ORACLE error 1741:
"CREATE SYNONYM "MIE_GOODS_DECL" FOR ""."MIE_GOODS_DECL"@"CEMS_MIE""
IMP-00003: ORACLE error 1741 encountered
ORA-01741: illegal zero-length identifier
查询语句：
select *
from dba_synonyms d where D.db_link IS NOT NULL AND D.table_owner IS NULL and d.owner ='CEMS';
select 'CREATE OR REPLACE SYNONYM '||SYNONYM_NAME||' FOR '||TABLE_NAME||'@'||db_link||';'
from dba_synonyms d where D.db_link IS NOT NULL AND D.table_owner IS NULL and d.owner ='CEMS';
后在CEMS用户下执行语句；
同义词带dblink,且table_owner为空的imp时报错，发现少部分能正常导入；与dblink是否有效无关；
解决办法，手工创建同义词：
IMP-00017: following statement failed with ORACLE error 1741:
"CREATE SYNONYM "MIE_GOODS_DECL" FOR ""."MIE_GOODS_DECL"@"CEMS_MIE""
IMP-00003: ORACLE error 1741 encountered
ORA-01741: illegal zero-length identifier
查询语句：
select *
from dba_synonyms d where D.db_link IS NOT NULL AND D.table_owner IS NULL and d.owner ='CEMS';
select 'CREATE OR REPLACE SYNONYM '||SYNONYM_NAME||' FOR '||TABLE_NAME||'@'||db_link||';'
from dba_synonyms d where D.db_link IS NOT NULL AND D.table_owner IS NULL and d.owner ='CEMS';
后在CEMS用户下执行语句；
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29519108/viewspace-1300716/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
