0 Replies Latest reply on Jun 21, 2018 2:22 PM by User287063

    HOW TO Re-ORG 4 workflow tables.

    User287063

      DB Tier - Exadata - 12.1.0.2 - Oracle Linux 6.7

      APP Tier - SLES SP 4

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------

      How To Purge E-Mail Notifications From The Workflow Queue So The E-Mail Is Not Sent (Doc ID 372933.1)

      How to Close and Purge Excessive WFERROR Workflows and DEFAULT_EVENT_ERROR Notifications from Workflow (Doc ID 1587923.1)

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------

      After following the notes above to purge excessive workflow notifications and related data, I now need to re-org the following four tables.

       

      WF_ITEMS

      WF_ITEM_ATTRIBUTE_VALUES

      WF_ITEM_ACTIVITY_STATUSES

      WF_NOTIFICATIONS

       

      Can a simple 'Alter Table Move' command accomplish this - or will the queues also need to be rebuilt?

       

      Looking at How Do I Reduce the High Watermark (HWM) of Advanced Queueing Objects? (Doc ID 421474.1), this provides information only upto 11gR1.

       

      We are on 12cR1

       

      Any help is appreciated.

       

      Thanks