Home » Server Options » Streams & AQ » Delete queue_table (oracle 9.2.0.8,solaris 9)
Delete queue_table [message #292555] Wed, 09 January 2008 03:37 Go to next message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
Hi all
i am droping a user.i run a script to delete all objects,but not able to delete queue table.suggest me the method.
Re: Delete queue_table [message #292557 is a reply to message #292555] Wed, 09 January 2008 03:42 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A queue can only be deleted with dbms_adadm package.

Regards
Michel
Previous Topic: DBMS_AQ.dequeue_array always returns 0 messages
Next Topic: streams database view
Goto Forum:
  


Current Time: Thu Mar 28 12:01:09 CDT 2024