Tag Archives: WF_DEFERRED_TABLE_M

How to rebuild WF_DEFERRED_TABLE_M Queue

Some 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 will proceed with the steps to rebuild the … Continue reading How to rebuild WF_DEFERRED_TABLE_M Queue »