Blogs >> Technology >>
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]
|