Dear Experts,

Thanks a lot for your advise and support to the needy.

I am in process of partitioning on DATE INTERVAL on existing table which holding the data.

1. Application team wants to partition for future data and no need to partition the old data which is there in the table until today, Is it possible without recreating/dropping the existing table.......I mean just add partition tomorrow onwards?

2. I went through
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:869096700346654484

If point 1 is not possible then what is the best way to achieve it in 12c ? is it dbms_redefinition is the only ways as explained in your answer (link) or we have other better method to do partition for existing tables?

Regards
Shah Nawaz

SQL> create table t as
  2  select owner, object_name, created
  3  from dba_objects
  4  where created is not null;

Table created.

SQL>
SQL>
SQL> create table t_par
  2  ( owner varchar2(128),
  3    object_name varchar2(128),
  4    created date )
  5  partition by range ( created )
  6  (
  7    partition p1 values less than ( date '2016-11-20' )
  8  );

Table created.

SQL>
SQL> alter table t_par exchange partition p1 with table t;

Table altered.