Oracle Table Partitioning

/*create TABLE Chukou

(

CAR_ID Number (Ten) is not NULL,

Car_date DATE,

Car_busnumber number

)

PARTITION by RANGE (car_date)

(

PARTITION Chukou_par01 VALUES Less THAN (to_date (' 17-11-2014 ', ' dd-mm-yyyy ') tablespace etltest_data,

PARTITION Chukou_par02 VALUES Less THAN (to_date (' 18-11-2014 ', ' dd-mm-yyyy ') tablespace etltest_data,

)

*/

--How many partitions on the query table SELECT * from user_tab_partitions WHERE table_name= ' Chukou '

--Add Table Partition ALTER table Chukou ADD PARTITION chukou_par03 VALUES less THAN (to_date (' 19-11-2014 ', ' dd-mm-yyyy '));

--Data maximum partition (used when several other partitions are undefined) ALTER TABLE chukou ADD PARTITION Part_max values less than (MaxValue);

--TRUNCATE partition reclaim space ALTER TABLE Chukou TRUNCATE PARTITION chukou_par02;

--Directly using DOP statement to delete and reclaim table Space ALTER table Chukou DROP PARTITION Chukou_par01;

Oracle Table Partitioning