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?