Oracle Schema objects--partition

Oracle Schema Objects

Table partitioning

Table - - Partitions ( Partition ) TABLE PARTITION

A period of time to give a partition, so as to facilitate the management of data.

You can follow the scope range range, list partition, hash partition, and so on.

To create a table partition:	sql> CREATE TABLE T_part (id int) 2 partition by range (ID) 3 (partition P1 values less than (5), 4 partition P2 values less than (ten), 5 partition Pmax values less than (MaxValue) 6 );
query Table partition:	sql> select * from T_part;  sql>select * from T_part partition (p1); sql> select * from T_part partition (P2); sql> select * from T_part partition (Pmax);  
To delete a partition:	sql> ALTER TABLE T_part drop partition P1;

Oracle Schema objects--partition