日期:2014-05-17  浏览次数:20904 次

10g怎么导出公共同义词
10g怎么导出公共同义词

------解决方案--------------------
SQL code

spool crpubsyn.sql

SELECT 'CREATE PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';'
FROM   dba_synonyms
WHERE  owner = 'PUBLIC';

spool off