日期:2014-05-17 浏览次数:20904 次
spool crpubsyn.sql SELECT 'CREATE PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';' FROM dba_synonyms WHERE owner = 'PUBLIC'; spool off