3 Replies Latest reply on Jan 11, 2018 3:43 AM by #MVivek

    Want to Drop Partition from GL_IMPORT_REFERENCES Table

    #MVivek

      Hi Oracle Experts,

       

      Need some clarification and guidance to drop partition from GL_IMPORT_REFERENCES table.

      We have 3 months data in XLA tables but we have more than 1 year data in GL_IMPORT_REFERENCES table.

       

      1. Is there any consequences to drop one year old partitions ?

      2. When we have only 3 months data in XLA tables, till when we need to keep the data in GL_IMPORT_REFERENCES table ?

      3. Proper steps to drop GL_IMPORT_REFERENCES table partitions without disturbing global_stats.

       

      Thanks

      Vivek