Choose Category
SELECT DBMS_METADATA.GET_DDL('TABLE', '<TABLENAME>’) AAA FROM DUAL
CREATE TABLE <TABLENAME> PARTITION BY RANGE ("BUS_DT") INTERVAL(NUMTODSINTERVAL(1, 'DAY')) (PARTITION "JAN_01_16" VALUES LESS THAN (TO_DATE(' 2016-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED) AS SELECT * FROM <TABLENAME>
SELECT * FROM USER_TAB_PARTITIONS WHERE UPPER(TABLE_NAME) = '<TABLENAME>’