3 Replies Latest reply on Apr 22, 2008 4:24 AM by user629987

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


      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)?