Drop a Queue Table

[lalleima]

HI

How can I drop a Queue Table?

Thanks

 

[ManjulaMadhu]

you must stop and drop all the queues in a queue tables before the queue table can be dropped. You must do this explicitly unless the force option is used in which case this done automatically.

Syntax:
DBMS_AQADM.DROP_QUEUE_TABLE (
queue_table IN VARCHAR2,
force IN BOOLEAN default FALSE,
auto_commit IN BOOLEAN default TRUE);

The operation will not succeed if there are any queues in the table.This is the default.
Make the force as TRUE: All queues in the table are stopped and dropped automatically.

From the PL/SQL :

EXECUTE dbms_aqadm.drop_queue_table (
queue_table => 'aq.Objmsgs_qtab',
force => TRUE);

 

[lalleima]

First of all I would like to thank U for Ur Piece of information. I knew we can use this package what I really wanted to know is somthing like.... what is the code of the procedure "DROP_QUEUE_TABLE".

And one more thing I have limited information about QUEUE tables any site where I can have somthing on that.

Thanks Again.

 

[ManjulaMadhu]

I am sure you can find this in the oracle documentation. anyway, check this:

http://www.csee.umbc.edu/help/oracle8/server.815/a68005/toc.htm