Home » Server Options » Streams & AQ » Removing Bad Queue Table
Removing Bad Queue Table [message #62248] Wed, 07 July 2004 11:58 Go to next message
Candy Robinson
Messages: 3
Registered: July 2004
Junior Member
I was trying to clean up our database by removing some of the Oracle supplied files that use the Example tablespace. I must have deleted something that the queue table qs.qs_orders_pr_mqtab needs, because it is no longer a valid object. I can't delete the user qs until I delete the queue table. I can't delete the table because I can't get delete privileges since the table has problems. I can't do a desc on it. It is causing tracefiles to multiply constantly because of the problems with this table. How do I remove QS??? Thanks in advance.
Re: Removing Bad Queue Table [message #62250 is a reply to message #62248] Wed, 07 July 2004 21:45 Go to previous message
Satheesh Babu.S
Messages: 35
Registered: July 2004
Member
If i understand your question correctly your are trying to drop the queue table using dbms_aqadm.drop_queue_table but not able to do that.
If you desprately want to drop the queue table then there is event called 10851

alter session set events '10851 trace name context forever, level 2';
then,
drop table <queue table>;

But be careful after this you *might* get ora-600 error, since inconsistency with the dictionary table.
Have a backup before doing this excersize.

Thanks and Regards,
Satheesh Babu.S
Bangalore.
Previous Topic: Streams - capturing and propagating only inserts on table
Next Topic: Apply Streams to a single database
Goto Forum:
  


Current Time: Thu Mar 28 04:42:56 CDT 2024