This discussion is archived
0 Replies Latest reply: Feb 8, 2010 8:00 AM by fechen RSS

Why not alter table?

fechen Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points