DBMS_METADATA 사용하기

[OBJECT_TYPE]

 - SELECT DISTINCT OBJECT_TYPE FROM DBA_OBJECTS;

 

EDITION
INDEX PARTITION
CONSUMER GROUP
SEQUENCE
TABLE PARTITION
SCHEDULE
QUEUE
RULE
JAVA DATA
PROCEDURE
OPERATOR
LOB PARTITION
DESTINATION
WINDOW
SCHEDULER GROUP
LOB
PACKAGE
PACKAGE BODY
LIBRARY
PROGRAM
RULE SET
CONTEXT
TYPE BODY
JAVA RESOURCE
XML SCHEMA
TRIGGER
JOB CLASS
UNDEFINED
DIRECTORY
MATERIALIZED VIEW
TABLE
INDEX
SYNONYM
VIEW
FUNCTION
JAVA CLASS
JAVA SOURCE
INDEXTYPE
CLUSTER
TYPE
RESOURCE PLAN
JOB
EVALUATION CONTEXT

 

 

[OBJECT SCRIPT 수집]

SET LINESIZE 200 (Range 1 ~ 32767)

SET PAGESIZE 10000 (Range 1 ~ 50000)

SET LONG 999999

 

SELECT DBMS_METADATA.GET_DDL('OBJECT_TYPE','OBJECT_NAME','OWNER') FROM DUAL;