Tag Archives: WF_DEFERRED_TABLE_M

How to rebuild WF_DEFERRED_TABLE_M Queue

Last updated on December 17th, 2017 at 05:31 pmSome times we need to rebuild the WF_DEFERRED_TABLE_M queue due to corruption. Here are the steps to perform it. First take a pre snapshot of all the objects related to that queue Login to server and source the EBS environment spool WF_DEFERRED_TABLE_M_objects_pre.lst select object_name, object_type, status, owner from dba_objects where object_name like ‘%WF_DEFERRED_TABLE_M%’; spool off 2) Now we … Continue reading How to rebuild WF_DEFERRED_TABLE_M Queue »