摘要:《DBMS_METADATA.GET_DDL (DDL Script 備份)》
2010/7/12 【DDL 備份 - DBMS_METADATA.GET_DDL】
[TABLE]
SELECT DBMS_METADATA.GET_DDL('TABLE',OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='TABLE';
[INDEX]
SELECT DBMS_METADATA.GET_DDL('INDEX', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='INDEX';
[VIEW]
SELECT DBMS_METADATA.GET_DDL('VIEW', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='VIEW';
[TRIGGER]
SELECT DBMS_METADATA.GET_DDL('TRIGGER', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='TRIGGER';
[PROCEDURE]
SELECT DBMS_METADATA.GET_DDL('PROCEDURE', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='PROCEDURE';
[FUNCTION]
SELECT DBMS_METADATA.GET_DDL('FUNCTION', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='FUNCTION';
[PACKAGE]
SELECT DBMS_METADATA.GET_DDL('PACKAGE', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='PACKAGE';
[SEQUENCE]
SELECT DBMS_METADATA.GET_DDL('SEQUENCE', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='SEQUENCE';
[MATERIALZED VIEW]
SELECT DBMS_METADATA.GET_DDL('MATERIALIZED_VIEW', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OWNER='SCOTT' AND OBJECT_TYPE='MATERIALIZED VIEW';
[DATABASE LINK]
SELECT OWNER, OBJECT_NAME,DBMS_METADATA.GET_DDL('DB_LINK', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OBJECT_TYPE='DATABASE LINK';
[SYNONYM]
SELECT OWNER, OBJECT_NAME,DBMS_METADATA.GET_DDL('SYNONYM', OBJECT_NAME,OWNER) FROM DBA_OBJECTS WHERE OBJECT_TYPE='SYNONYM';
-----------------------------------------------------------------------
SQL>DESC DBMS_METADATA
FUNCTION ADD_TRANSFORM RETURNS NUMBER
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
NAME VARCHAR2 IN
ENCODING VARCHAR2 IN DEFAULT
PROCEDURE CLOSE
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
FUNCTION FETCH_CLOB RETURNS CLOB
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
PROCEDURE FETCH_CLOB
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
XMLDOC CLOB IN/OUT
FUNCTION FETCH_DDL RETURNS KU$_DDLS
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
FUNCTION FETCH_DDL_TEXT RETURNS VARCHAR2
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
PARTIAL NUMBER OUT
FUNCTION FETCH_XML RETURNS XMLTYPE
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
PROCEDURE FREE_CONTEXT_ENTRY
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
IND NUMBER IN
FUNCTION GET_DDL RETURNS CLOB
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
OBJECT_TYPE VARCHAR2 IN
NAME VARCHAR2 IN
SCHEMA VARCHAR2 IN DEFAULT
VERSION VARCHAR2 IN DEFAULT
MODEL VARCHAR2 IN DEFAULT
TRANSFORM VARCHAR2 IN DEFAULT
FUNCTION GET_DEPENDENT_DDL RETURNS CLOB
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
OBJECT_TYPE VARCHAR2 IN
BASE_OBJECT_NAME VARCHAR2 IN
BASE_OBJECT_SCHEMA VARCHAR2 IN DEFAULT
VERSION VARCHAR2 IN DEFAULT
MODEL VARCHAR2 IN DEFAULT
TRANSFORM VARCHAR2 IN DEFAULT
OBJECT_COUNT NUMBER IN DEFAULT
FUNCTION GET_DEPENDENT_XML RETURNS CLOB
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
OBJECT_TYPE VARCHAR2 IN
BASE_OBJECT_NAME VARCHAR2 IN
BASE_OBJECT_SCHEMA VARCHAR2 IN DEFAULT
VERSION VARCHAR2 IN DEFAULT
MODEL VARCHAR2 IN DEFAULT
TRANSFORM VARCHAR2 IN DEFAULT
OBJECT_COUNT NUMBER IN DEFAULT
FUNCTION GET_DOMIDX_METADATA RETURNS KU$_VCNT
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
INDEX_NAME VARCHAR2 IN
INDEX_SCHEMA VARCHAR2 IN
TYPE_NAME VARCHAR2 IN
TYPE_SCHEMA VARCHAR2 IN
FLAGS NUMBER IN
FUNCTION GET_GRANTED_DDL RETURNS CLOB
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
OBJECT_TYPE VARCHAR2 IN
GRANTEE VARCHAR2 IN DEFAULT
VERSION VARCHAR2 IN DEFAULT
MODEL VARCHAR2 IN DEFAULT
TRANSFORM VARCHAR2 IN DEFAULT
OBJECT_COUNT NUMBER IN DEFAULT
FUNCTION GET_GRANTED_XML RETURNS CLOB
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
OBJECT_TYPE VARCHAR2 IN
GRANTEE VARCHAR2 IN DEFAULT
VERSION VARCHAR2 IN DEFAULT
MODEL VARCHAR2 IN DEFAULT
TRANSFORM VARCHAR2 IN DEFAULT
OBJECT_COUNT NUMBER IN DEFAULT
FUNCTION GET_QUERY RETURNS VARCHAR2
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
FUNCTION GET_XML RETURNS CLOB
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
OBJECT_TYPE VARCHAR2 IN
NAME VARCHAR2 IN
SCHEMA VARCHAR2 IN DEFAULT
VERSION VARCHAR2 IN DEFAULT
MODEL VARCHAR2 IN DEFAULT
TRANSFORM VARCHAR2 IN DEFAULT
FUNCTION OPEN RETURNS NUMBER
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
OBJECT_TYPE VARCHAR2 IN
VERSION VARCHAR2 IN DEFAULT
MODEL VARCHAR2 IN DEFAULT
PROCEDURE SET_COUNT
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
VALUE NUMBER IN
PROCEDURE SET_DEBUG
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
ON_OFF BOOLEAN IN
PROCEDURE SET_FILTER
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
NAME VARCHAR2 IN
VALUE VARCHAR2 IN
PROCEDURE SET_FILTER
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
NAME VARCHAR2 IN
VALUE BOOLEAN IN DEFAULT
PROCEDURE SET_PARSE_ITEM
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
HANDLE NUMBER IN
NAME VARCHAR2 IN
PROCEDURE SET_TRANSFORM_PARAM
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
TRANSFORM_HANDLE NUMBER IN
NAME VARCHAR2 IN
VALUE VARCHAR2 IN
PROCEDURE SET_TRANSFORM_PARAM
參數名稱 類型 In/Out 預設值？
------------------------------ ----------------------- ------ --------
TRANSFORM_HANDLE NUMBER IN
NAME VARCHAR2 IN
VALUE BOOLEAN IN DEFAULT
