oracle에서 synonym 리스트 출력하기

 

SELECT * FROM DBA_SYNONYMS

SELECT * FROM ALL_SYNONYMS

SELECT * FROM USER_SYNONYMS

DROP SYNONYM  synonym_name

출처 : http://kin.naver.com/db/detail.php?d1id=1&dir_id=10110&eid=E2JXmm1a7zG0wnmaMi4nQwqCIP+oGDKU&qb=c3lub255bQ==