10g如何导出公共同义词

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

[解决办法]

SQL code

spool crpubsyn.sqlSELECT 'CREATE PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';'FROM   dba_synonymsWHERE  owner = 'PUBLIC';spool off