Oracle Table Partitioning

--Range Partitioning
--Build a table
CREATE TABLE Orders
(
ORDER_ID Number (12),
Order_date date NOT NULL,
Order_total Number (8,2)
)
Partition by RANGE (order_date)
(
Partition P1 VALUES less than (to_date (' 2015-01-01 ', ' yyyy-mm-dd ')),
Partition P2 VALUES less than (MaxValue)
)
INSERT into orders VALUES (1,sysdate,200)

SELECT * FROM orders partition (P1)

SELECT Table_name,partition_name
From User_tab_partitions
WHERE table_name=upper (' orders ');

Oracle Table Partitioning