Subscriber Count

    459

Subscribe to Posts by Email

Pages

12c Database : Interval Partitioning enhancements – 2

From 12c, interval partitions has been enhanced to use reference partitioning, With this you can create a parent/child table with references in them using interval partitioning.

The following is the test case.

Create table EMPLOYEE ( EMPLOYEE_ID number primary key, EMPLOYEE_NAME varchar(25), JOINING_DATE date) PARTITION BY RANGE (JOINING_DATE) INTERVAL (NUMTOYMINTERVAL(1,'YEAR')) ( PARTITION P_2013_06 VALUES LESS […]

12c Database : Multiple Partitions maintainance in one go

Before to 12c, if you want to maintain partitions you will need to execute that many alter statements partition commands that many times.

For example to add p7,p8 partitions, you have to use

SQL> alter table test_tbl add partition p7 values less than (7) SQL> alter table test_tbl add partition p8 values less than […]