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.

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
A queue can only be deleted with dbms_adadm package.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 11 16:44:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.