This content has been marked as final. Show 4 replies
If altering the user defined type on which the queue is based you must drop the queue (and the queue table) and rebuild them.
thanks damorgan, can you please write the steps/sequence here, because I think it's not simple to drop & re-create a very old queue, having some queues, can you please assist here.
in order to rebuild an AQ you have to stop the queue, then drop it and then drop the corresponding queue table:
Then you can rebuild (better than ALTER) your queue type.
BEGIN SYS.DBMS_AQADM.STOP_QUEUE ( QUEUE_NAME => '<name>'); SYS.DBMS_AQADM.DROP_QUEUE ( QUEUE_NAME => '<name>'); END; / BEGIN SYS.DBMS_AQADM.DROP_QUEUE_TABLE (QUEUE_TABLE => '<name>'); END; /
Drop and re-create ... no other option