This content has been marked as final. Show 3 replies
Oracle ILM refers to all the capabilities in the database which can be used to build an ILM solution.
The Oracle ILM Assistant is a GUI tool which helps you build an ILM solution but it only supports some of the capabilities that can be used within Oracle ILM
So your assumption is correct that in order to use the ILM Assistant in 9i or 10g the table must be using range partitioned.
You can still build an ILM solution using say List partitioning, you just can't use the ILM Assistant.
Hope this clarifies the situation
How would the ILM solution using list partitioning be built and managed, if ILM Assistant cannot be used?
Since only range partitioning is possible, doesn't this make ILM Assistant limited in possibilities?
Hi, i believe the List partitioning can be used for example in the case of
'phase-out' products, with Product ID as the partitioning key and depends on how it is grouped.
Anyway, any further study on the ILM working with 11g on this aspect, in terms of
the restriction (parititioning-options) that ILM can work with??
Edited by: user1242355 on Feb 24, 2009 5:11 PM
Edited by: user1242355 on Feb 24, 2009 5:13 PM