Metadata DDL 추출 -- DB_LINK SELECT DBMS_METADATA.get_ddl ('DB_LINK', db_link, owner) FROM dba_db_links order by owner,username; -- JOB SET SERVEROUTPUT ON SET LINESIZE 4000 DECLARE CURSOR C1 IS SELECT JOB FROM DBA_JOBS WHERE UPPER(WHAT) LIKE '%DBMS_REFRESH%' ORDER BY JOB; CNT INTEGER:=1; JOB_NO BINARY_INTEGER; CALLSTR VARCHAR2(1000); BEGIN SELECT COUNT(1) INTO CNT FROM DBA_JOBS WHERE UPPER(WHAT) LIKE '%DBMS_REFR.. 더보기 이전 1 ··· 3 4 5 6 7 8 9 ··· 219 다음