spool createpubsyn.sql SELECT 'CREATE PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';' FROM dba_synonyms WHERE owner = 'PUBLIC'; spool off |
如何导出公有同义词
最新推荐文章于 2024-03-18 17:59:28 发布
spool createpubsyn.sql SELECT 'CREATE PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';' FROM dba_synonyms WHERE owner = 'PUBLIC'; spool off |