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.