INVALID object 재생성 script (owner 변경 등)

SELECT OWNER, OBJECT_NAME,
       REGEXP_REPLACE(dbms_metadata.get_ddl(object_type, object_name, owner),
           '찾을내용', '변경할내용', 1, 0, 'i') || ';' sql
FROM dba_objects
WHERE owner IN ('스키마')
AND status <> 'VALID'
AND object_type IN ('VIEW', 'SYNONYM', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TRIGGER')
ORDER BY OWNER, OBJECT_NAME;