Purging And Re-Org Of FND_CP_GSM_OPP_AQTBL To Resolve Post-Processing Error.
Sign in

Purging and re-org of FND_CP_GSM_OPP_AQTBL to resolve post-processing error.

Purging and re-org of  FND_CP_GSM_OPP_AQTBL to resolve post-processing error.

exec DBMS_AQADM.STOP_QUEUE('FND_CP_GSM_OPP_AQ');
exec dbms_aqadm.purge_queue_table('FND_CP_GSM_OPP_AQTBL', null, null);
exec move_aqt.move('APPLSYS','FND_CP_GSM_OPP_AQTBL', 'APPS_TS_TX_DATA');
exec DBMS_AQADM.START_QUEUE ('FND_CP_GSM_OPP_AQ');

 

May Refer below articles:

 

How To Purge Fnd_AQ Tables [ID 1156523.1]
How to Move Queue Tables without using the Export or Datapump Utilities [ID 304522.1]

start_blog_img