3 Replies Latest reply: Apr 21, 2008 11:24 PM by user629987 RSS

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

    user629987
      Hi,

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

      Thanks!