DBMS_METADATA.GET_DDL is returning NOCOMPRESS, NOLOGGING etc.
How can the NOCOMPRESS and 'NLS_CALENDAR=GREGORIAN' (and sometimes NOLOGGING) clause can be avoided in the output plese?We are on 10.2.0.5SQL> set linesize 10000SQL> exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);SQL> exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES',false);SQL> SELECT DBMS_METADATA.GET_DDL ('TABLE','RANGE_SALES','CHAKRAA4') from dual;DBMS_METADATA.GET_DDL('TABLE','RANGE_SALES','CHAKRAA4') -------------------------------------------------
CREATE TABLE "CHAKRAA4"."RANGE_SALES"
( "PROD_ID" NUMBER(6,0),
"CUST_ID" NUMBER,
"TIME_ID" DATE,
"CHANNEL_ID" CHAR(1),
"PROMO_ID" NUMBER(6,0),
"QUANTITY_SOLD" NUMBER(3,0),
"AMOUNT_SOLD" NUMBER(10,2)
CREATE TABLE "CHAKRAA4"."RANGE_SALES"
( "PROD_ID" NUMBER(6,0),
"CUST_ID" NUMBER,
"TIME_ID" DATE,
"CHANNEL_ID" CHAR(1),
"PROMO_ID" NUMBER(6,0),
"QUANTITY_SOLD" NUMBER(3,0),
"AMOUNT_SOLD" NUMBER(10,2)
0