myorama
7/25/2018 - 5:50 AM

Get profile default ddl

dbms_metadata.get_ddl.sql
content_copyfile_download
set long 20000 longchunksize 20000 pagesize 0 linesize 1000 feedback off verify off trimspool on
column ddl format a1000

begin
   dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'SQLTERMINATOR', true);
   dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'PRETTY', true);
end;
/

select dbms_metadata.get_ddl('PROFILE', 'DEFAULT') as profile_ddl from dual;