SYNONYM 자동 생성

SYNONYM 자동 생성

SELECT ‘CREATE SYNONYM ‘||OBJECT_NAME||’ FOR ‘||OWNER||’.’||OBJECT_NAME||’;’ FROM ( SELECT OWNER, OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE IN (‘TABLE’,’TABLE PARTITION’,’VIEW’) AND (OWNER LIKE ‘ODS%’ OR OWNER LIKE ‘DW%’) MINUS SELECT OWNER, OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE = ‘SYNONYM’ AND OWNER = ‘APPS’ AND OBJECT_NAME LIKE ‘%TB%’ )