10g怎么导出公共同义词
------解决方案--------------------
- SQL code
spool crpubsyn.sqlSELECT 'CREATE PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';'FROM dba_synonymsWHERE owner = 'PUBLIC';spool off
spool crpubsyn.sqlSELECT 'CREATE PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';'FROM dba_synonymsWHERE owner = 'PUBLIC';spool off