Sample SQL for Enabling ILM for CCB (Initial Install)
This section provides more detail about steps needed to fully support ILM on tables for maintenance objects that support the functionality. Two maintenance objects are shown:
• To Do Entry, which does not include a LOB field.
• Sync Request, which does include a LOB field.
Other maintenance object's implementations can follow the appropriate pattern based on whether there is a LOB field or not.
The following DDL(s):
• Follow Naming convention recommendations for partitions\subpartitions\tablespaces.
• Ensure all the ILM Storage requirements are incorporated, failing which, ILM functionality will not be achieved.
• Partitions are defined with respective Tablespace.
• Child Tables are referenced partitioned.
• Make sure all compression recommendations are incorporated.