Oracle Table Partitioning

Oracel table partitioning can basically be divided into several categories:
-Range (range) partition
-Hash (hash) partition
-List partition
-Combined partition: Range-hash, Range-list.

1.Range (range) partition create partition Table

create   TABLE  table_partition (COL1 number , COL2 VARCHAR2 (100 )) partition by  Range (COL1) (Partition Tab_partot ion_01 values  less than (450000 ), partition tab_partotion_02 values  less than (900000 ), Partition tab_partotion_03 values  less than (1350000 ), partition tab_partotion_04 values  less than (1800000 ), partition tab_partotion_other values  less THAN (MAXVALUE ) ); 

Inserting test data

 INSERT  into Table_partition (col1,col2)VALUES(1,' data test '); INSERT  into Table_partition (col1,col2)VALUES("Data Test"); INSERT  into Table_partition (col1,col2)VALUES(449000,' data test ' ); INSERT  into Table_partition (col1,col2)VALUES(450000,' data test '); INSERT  into Table_partition (col1,col2)VALUES(1350000,' data test ' ); INSERT  into Table_partition (col1,col2)VALUES(900000,' data test ' );  INSERT  into Table_partition (col1,col2)VALUES(1800000-1,' Data test '); COMMIT;

View data in a partition

SELECT * FROM TABLE_PARTITION partition(TAB_PARTOTION_02);

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Oracle Table Partitioning