--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
阅读(2198) | 评论(0) | 转发(0) |