0 Replies Latest reply: Feb 8, 2010 10:00 AM by fechen RSS

    Why not alter table?

    fechen
      Hi,

      I used the ILM assistant to associate the lifecycle with a table. The ILM assistant generated a partition migration script. Basically a new intermediate table was created and data was copied from the old table to the intermediate table, then the intermediate table was renamed. I am wondering instead of doing this, why not use the "alter table add partition" sql statement? Any problem with "alter table" or any advantage of creating a new table?

      Thanks,
      -Fengting