This discussion is archived
0 Replies Latest reply: Mar 2, 2010 12:57 AM by user8773096 RSS

Alternative Placement Approach

user8773096 Newbie
Currently Being Moderated
Alternative Placement Approach that does not require partitioning on a date column

Extract of text obtained directly from the ILM Assistant online help guideline.........

For tables that are not partitioned, the ILM Assistant now permits an alternative placement approach that does not require partitioning on a date. If a table is small or has incompatible attributes, the user may manage the table by allowing it to be placed as a whole object. Just as one does with a partition candidate, the table will be associated with a lifecycle. However, instead of requiring the table to have a date column, the Assistant will prompt the user for a specific date value. That date value will then be used by the Assistant to evaluate correct placement.

Just wonder if anyone knows how to go about the above?

Thanks & regards,


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