Admin/admin

Corruption of queue 'FND_CP_GSM_IPC_AQTBL'

Qhtlr 2009. 5. 20. 11:37

Log into SQLPlus as APPLSYS user and execute the following:

exec DBMS_AQADM.STOP_QUEUE('FND_CP_GSM_IPC_AQ');

exec DBMS_AQADM.DROP_QUEUE('FND_CP_GSM_IPC_AQ');

exec DBMS_AQADM.DROP_QUEUE_TABLE('FND_CP_GSM_IPC_AQTBL');

exec DBMS_AQADM.CREATE_QUEUE_TABLE(queue_table => 'FND_CP_GSM_IPC_AQTBL', -
queue_payload_type => 'SYSTEM.FND_CP_GSM_IPQ_AQ_PAYLOAD', -
sort_list => 'priority,enq_time', -
multiple_consumers => TRUE, -
comment => 'IPC for GSM Generic Cartridge', -
compatible => '8.1');

exec DBMS_AQADM.CREATE_QUEUE ('FND_CP_GSM_IPC_AQ', FND_CP_GSM_IPC_AQTBL');

exec DBMS_AQADM.START_QUEUE ('FND_CP_GSM_IPC_AQ');