环境: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博客 ” ,链接:http://blog.itpub.net/29519108/viewspace-1300716/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29519108/viewspace-1300716/