0 Replies Latest reply on Feb 8, 2010 4:00 PM by Fechen-Oracle

    Why not alter table?


      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?