-- Hide what we don't want to see
begin
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'SQLTERMINATOR', true);
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'SEGMENT_ATTRIBUTES', false);
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'STORAGE', false);
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'REF_CONSTRAINTS', false);
dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'CONSTRAINTS', false);
end;
/
col ddl for a512
set long 999999
set lines 512 trimspool on pages 0 echo off head off feed off
spool table_ddl.sql
select dbms_metadata.get_ddl('TABLE', 'MY_TABLE', 'DTS') ddl from dual;
spool off
spool mlog_ddl.sql
select dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG', 'MLOG$_MY_TABLE', 'DTS') ddl from dual;
spool off
spool mview_ddl.sql
select dbms_metadata.get_ddl('MATERIALIZED_VIEW', 'MY_MVIEW', 'DTS') ddl from dual;
spool off
exit