Oracle 11g Partitioning

1. Interval partition

The interval partition is an enhancement of range partitioning, enabling automation of range partitioning that automatically creates new partitions and local indexes.

Test examples:

Create a partition table first,

Write data that is not in the partition range

The view partition has been created automatically, but the partition name cannot be specified, and this seems to be not smart for backup cleanup based on the partition name.

DROP TABLEEDU. TEST23 PURGE/CREATE TABLEEDU. TEST23 (ID Number( A), NAMEVARCHAR2( -), create_date DATE) PARTITION byRANGE (create_date) INTERVAL (Numtoyminterval (1,'MONTH')) (PARTITION P201602VALUESLess THAN (To_date ('20160201','YYYYMMDD')))/Insert  intoedu.test23Values(1,'1', Sysdate)/CREATE TABLEEDU. TEST23 (ID Number( A)NULL, NAMEVARCHAR2( -)NULL, Create_date DATENULL) tablespace UserspctfreeTenpctused0Initrans1Maxtrans255STORAGE (Buffer_poolDEFAULT) Noparallelnocachepartition byRANGE (create_date) (PARTITION P201602VALUESLess THAN (To_date ('2016-02-01 00:00:00','SYYYY-MM-DD HH24:MI:SS','Nls_calendar=gregorian')) LOGGING, PARTITION sys_p62VALUESLess THAN (To_date ('2016-04-01 00:00:00','SYYYY-MM-DD HH24:MI:SS','Nls_calendar=gregorian')) LOGGING)/

2. Foreign Key Partitioning

Using foreign keys to get the partition scheme of the main table

For example: the main table according to the create_date partition, the table containing the foreign key through the foreign key, you can follow the main table create_date partition.

3. Virtual Column Partitioning

One or more columns in the table are allowed to be used to determine the partition, and the virtual column is stored as metadata only.

Oracle 11g Partitioning