Database Administration (MOSC)

MOSC Banner

DBMS_METADATA.GET_DDL is returning NOCOMPRESS, NOLOGGING etc.

edited Feb 23, 2013 4:32PM in Database Administration (MOSC) 3 commentsAnswered ✓
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center