1 Reply Latest reply: Jun 25, 2007 6:56 AM by 543302 RSS

    Can we use "List Partition" in ILM?

    474148
      HI Everyone,

      I after going through documents observed that the frequently used Partitioning technique by ILM Assistant is the "Range Partitioning".

      How can we implement "List Partitioning"?

      Also, as there is a way to Generate script to execute events for "Managed
      tables"

      can we generate script to execute events for "Simulated Tables" or is there a way to automate it ?


      Thanks in advance

      Regards
      Rakesh
        • 1. Re: Can we use "List Partition" in ILM?
          543302
          Hi Rakesh,

          We are definitely considering alternate partitioning approaches for future releases, including List partitioning.

          For simulated tables, we could generate a representative script; however, it would not execute properly, since partitioning is simulated within the Assistant. Instead, we chose to allow the user to implement the simulated events as if a script had been executed. Again, since the table modifications and movement are simulated, implementing simulated events only pretends to make changes to table objects within the ILM Assistant.

          Thanks,

          Greg