Thursday, 14 June 2012

dbms_metadata.get_ddl for entire schema's scripts


  1.  SELECT DBMS_METADATA.GET_DDL('TABLE','EMP') FROM DUAL;
  2. SELECT DBMS_METADATA.GET_DEPENDENT_DDL('INDEX','EMP') FROM DUAL;
  3. EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM, 'STORAGE', FALSE);
  4.  EXEC DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM, 'TABLESPACE', FALSE);


No comments:

Post a Comment