How to partition an existing Oracle table?
Posted on 2011-03-17
We have an Oracle 11.0.2 Database and the tables in it has an average size of approximately 5 GB.
We need to partition these existing tables (interval partitioning) according to the selected time period using an existing field with DATE type. This field is common in all tables. Some of the tables will be partitioned daily, some of them will be partitioned monthly etc.
How can I convert these un-partitioned tables to interval partitioned tables (range partition + auto-increment) without disturbing data or recreating the tables?