Core Workflow - EBS (MOSC)

MOSC Banner

Which indexes and tables needs to rebuild after workflow purge

edited Oct 9, 2012 10:33PM in Core Workflow - EBS (MOSC) 17 commentsAnswered
Hi All

We always purge old workflow data by using seeded conc req "Purge obsolote Workflow runtime data" and via Seeded API WF_ITEMS.purge etc.

But, after that which workflow tables and indexes  needs to be rebuild so that we can reset the High water mark and save the space?

I think we can only rebuild only certain indexes on  following tables. But how to rebuid those tables? Is there any standard methods?

'WF_ITEMS',
'WF_ITEM_ACTIVITY_STATUSES',
'WF_ITEM_TYPES',
'WF_ITEM_ACTIVITY_STATUSES_H'

Regards

Nikhil Wani

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center