0 Replies Latest reply on May 4, 2015 12:00 PM by Sharkie

    Purge to Archive

    Sharkie

      Hi

       

      We need to purge and archive a large amount of data. Currently the table sits at 20000000 lines and is having a massive impact on performance. However the notifications (WF) fall out the scope of the seeded archive processes that Oracle supplies.

       

      Any one had experience in archiving custom notifications? Any Oracle supplied apis or suggested routes we can be pointed to.

       

      I have asked Oracle and all they confirmed was the WF tables that are purged during the purge process.

       

      Thanks

       

      Andrew