导出Oracle中的同义词

1. --导出所有的同义词
   
2. SELECT 'CREATE OR REPLACE PUBLIC SYNONYM ' || '"' || SYNONYM_NAME || '"' ||
   
3.        ' FOR ' || '"' || TABLE_OWNER || '"' || '.' || '"' || TABLE_NAME || '"' || ';'
   
4.   FROM DBA_SYNONYMS A
   
5. WHERE A.TABLE_OWNER IN ('ACCT','BLDBANK','COMM','CPR','ECONSTAT','EQUIPMENT','EXAM','INFECT','INPADM','INPBILL','INQUIRE','INSURANCE','LAB',
   
6. 'MEDADM','MEDREC','NURSING','ORDADM','OUTPADM','OUTPBILL','OUTPDOCT','PHARMACY','PHYEXAM','SURGERY','TJRIS') ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28878983/viewspace-2133893/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28878983/viewspace-2133893/