Synonym

생성 권한

--owner_name에 대해 Public Synonym 생성 권한 부여
GRANT CREATE PUBLIC SYNONYM TO owner_name;

--일반 Synonym 생성 권한 부여
GRANT CREATE SYNONYM TO owner_name;

확인

SELECT * FROM ALL_SYNONYMS;

생성

CREATE SYNONYM synonym_name FOR object_name;
CREATE PUBLIC SYNONYM synonym_name FOR object_name;

DB Link와 연결 시

CREATE PUBLIC SYNONYM synonym_name FOR object_name@database_link_name;

삭제

DROP SYNONYM synonym_name;
DROP PUBLIC SYNONYM synonym_name;