DBMS_METADATA.GET_DDL获取DDL

--remove storage
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);
--remove tablespace
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'TABLESPACE',false);
--remove SEGMENT_ATTRIBUTES
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES',false);
--table struts
SELECT DBMS_METADATA.GET_DDL('TABLE','ALERT_SUMMARY','SPP') FROM DUAL;
--grant privilege
SELECT DBMS_METADATA.GET_DEPENDENT_DDL('OBJECT_GRANT','CTL_PROC_SUM_DATA_NEW','SPAPP') FROM DUAL;

 

Reference

http://hi.baidu.com/_linzi_/blog/item/eb751fdd2e1f48305982ddd3.html