SESSION_TRANSFORM

SESSION_TRANSFORM procedure modifies or customizes the output generated by the dbms_metadata.get_ddl procedure.  If you like to extract DDL structure for a table without storage, constraint, reference constraint for a table, you can set these parameters to false.  See example below…

SQL> begin dbms_metadata.set_transform_param(dbms_metadata.session_transform,'STORAGE', false);

  2   dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS',false);

  3  dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'SQLTERMINATOR',TRUE);

  4  dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'CONSTRAINTS', false);

  5  end;

  6  /

PL/SQL procedure successfully completed.

SQL> select dbms_metadata.get_ddl('TABLE','POLICY') from dual;