SQL> begin
2 dbms_metadata.set_transform_param
3 ( DBMS_METADATA.SESSION_TRANSFORM,
4 ‘CONSTRAINTS_AS_ALTER’, true );
5 dbms_metadata.set_transform_param
6 ( DBMS_METADATA.SESSION_TRANSFORM, ‘STORAGE’, false
7 );
8 dbms_metadata.set_transform_param
9 ( DBMS_METADATA.SESSION_TRANSFORM, ‘SQLTERMINATOR’,
10 TRUE );
11 end;
12 /
PL/SQL procedure successfully completed.
SQL> commit ;
Commit complete.
SQL> select
2 dbms_metadata.get_ddl( ‘TABLE’, table_name, owner ) x
3 from dba_tables
4 where owner=’HR’ ;
X
———————————————————————-
CREATE TABLE “HR”.”REGIONS”
( “REGION_ID” NUMBER CONSTRAINT “REGION_ID_NN
CREATE TABLE “HR”.”LOCATIONS”
( “LOCATION_ID” NUMBER(4,0),
“STREET_ADDR
…
tablolar, indexler, paketler vs. hepsinin DDL yedekleri günlük olarak basit bir job ile otomatikleştirilebilinir.