Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

PARTITION in Oracle

To get the structure of a table with partition details
SELECT DBMS_METADATA.GET_DDL('TABLE', '<TABLENAME>’) AAA FROM DUAL

Creating new table with partition with the data from another table
Range and Interval partitions
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>

To view partition details of a table
SELECT * FROM USER_TAB_PARTITIONS 
WHERE UPPER(TABLE_NAME) = '<TABLENAME>’