This discussion is archived
3 Replies Latest reply: Apr 21, 2008 9:24 PM by user629987 RSS

How to create partitions when table with millions of rows already exists?

user629987 Newbie
Currently Being Moderated

Is it possible to partition (old) data that already exists in the table (for example, last year's data), or is it only possible to partition new data (next year's data)?

If yes, Can someone give me some examples (SQL scripts) on how to partition a table (per month) to implement ILM on a table which already exists and has millions of rows of data (therefore, not with the Create Table statement)?