This content has been marked as final. Show 3 replies
Under the setup tab of the ILM Assistant, you can get partitioning advice. In addition, the ILM Assistant can generate a SQL script to partition your table for you. To do this, first set up your storage tiers and lifecycle definitions. Then assign your table to the lifecycle. At that point the ILM Assistant will give you advice on partitioning your table and can generate the script.
As jack said the ILM Assistant will give you a script or you can work it out yourself and good reference is the VLDB book in 11g or the Data Warehousing guide in 10gR2.
Do you have a direct link to these references? I can't seem to access them via the Oracle site.