ORACLEÈçºÎʹÓÃDBMS_METADATA.GET_DDL»ñÈ¡DDLÓï¾ä

1.µÃµ½Ò»¸ö±íµÄddlÓï¾ä£º
SET SERVEROUTPUT ON
SET LINESIZE 1000
SET FEEDBACK OFF
set long 999999             ------ÏÔʾ²»ÍêÕû
SET PAGESIZE 1000    ----·ÖÒ³
 
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);  ---È¥³ýstorageµÈ¶àÓà²ÎÊý
 
SELECT DBMS_METADATA.GET_DDL('TABLE','TCC_NE_FRAME') from DUAL;
SELECT DBMS_METADATA.GET_DDL('TABLE','TCC_NE_SNAP') from DUAL;
 
2.µÃµ½Ò»¸öÓû§ÏµÄËùÓÐ±í£¬Ë÷Òý£¬´æ´¢¹ý³ÌµÄddl
 
SET SERVEROUTPUT ON
SET LINESIZE 1000
SET FEEDBACK OFF
set long 999999  ------ÏÔʾ²»ÍêÕû
SET PAGESIZE 1000  ----·ÖÒ³
---È¥³ýstorageµÈ¶àÓà²ÎÊý
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);
 
SELECT DBMS_METADATA.GET_DDL(U.OBJECT_TYPE, u.object_name)
  from USER_OBJECTS u
 where U.OBJECT_TYPE IN ('TABLE','INDEX','PROCEDURE');
 
3.µÃµ½ËùÓбí¿Õ¼äµÄddlÓï¾ä
 
SET SERVEROUTPUT ON
SET LINESIZE 1000
SET FEEDBACK OFF
set long 999999------ÏÔʾ²»ÍêÕû
SET PAGESIZE 1000----·ÖÒ³
---È¥³ýstorageµÈ¶àÓà²ÎÊý
 
SELECT DBMS_METADATA.GET_DDL('TABLESPACE', TS.tablespace_name)
from DBA_TABLESPACES TS;
4.µÃµ½ËùÓд´½¨Óû§µÄddl
 
SET SERVEROUTPUT ON
SET LINESIZE 1000
SET FEEDBACK OFF
set long 999999------ÏÔʾ²»ÍêÕû
SET PAGESIZE 1000----·ÖÒ³
---È¥³ýstorageµÈ¶àÓà²ÎÊý
 
SELECT DBMS_METADATA.GET_DDL('USER',U.username)
from DBA_USERS U;