Adding table partition automatically to a partitioned table ( Oracle 11g feature)

Article: Adding table partition automatically to a partitioned table ( range partition)
Applicable: Oracle database version more than 11.1.x.x ( Oracle 11g exclusive )

Note: This feature in Oracle 11g releases headac of Oracle DBA to add table-partions manually. This is execlusivly available in Enterprise version and payble option with Oracle.

E.g.

-- Create a table with range partition

sql> create table hr.employee (eno number(10), ename varchar2(100))
 partition by range (nu) (
 partition part1 values less than(100000)
 tablespace users);

-- Execute the command at any time to add partion automatically

sql> alter table hr.employee set interval (100000);