Current Position:Home > Cannot drop user -must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

Cannot drop user -must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

Update:11-30Source: network consolidation
Advertisement
Hi,
I had this issue before, but forgot the command that should be used to flush some kind of a trash bin.
Can someone assist me?
Thanks!

The Best Answer

Advertisement
Hi,
Use this link :
Re: Unable to drop USERS tablespace.
  • Dropping queue table Update:11-30

    hi I am tryin to drop a schema devj2ee with the following command: SQL> drop user devj2ee cascade; drop user devj2ee cascade ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop q

  • Unable to drop queue table Update:10-11

    Hi, I have the streams admin user as "stradmin" and i have a queue table called "STREAMS_CAPTURE_QT" I am not able to drop the streams user because i am not able to drop the queue table. I tried the following..... begin DBMS_AQADM.DROP

  • Cannot drop user -must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables Update:11-30

    Hi, I had this issue before, but forgot the command that should be used to flush some kind of a trash bin. Can someone assist me? Thanks!Hi, Use this link : Re: Unable to drop USERS tablespace.Read other 3 answers

  • Problem with Queue Table while dropping schema Update:10-11

    Hi, I want to DROP a schema, but it gives the following error while trying to drop it: ORA-00604: error occurred at recursive SQL level 1 ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables From TOAD, I found that no queue or queue_t

  • Error while dropping/creating new queue table Update:10-11

    Hi, I am trying to modify an existing AQ setup. In the process, I had to remove a queue and redirect all its subscriptions to another queue. I get an oracle "sequence does not exist" while trying to drop the queue table. The sequence of operatio

  • DBMS_AQADM.DROP_QUEUE_TABLE  PROBLEM Update:10-11

    Hi! I import by mistake the table DEF$_AQCALL in my user shema. When I try to drop this table, Oracle tell me for use the DBMS_AQADM.DROP_QUEUE_TABLE function . When I execute this function I receive this message ORA-24002: QUEUE_TABLE MYUSER.DEF$_AQ

  • Cannot drop queue objects - invalid username/password Update:11-30

    Folks - I'm having an issue where I cannot drop the user that owns my AQ/streams objects from an 11g database. [email protected]> drop user streams cascade; drop user streams cascade ERROR at line 1: ORA-24008: queue table STREAMS.LB_SUBS_SOURCE_QT must b

  • Dropping the Hight Water Mark on a Queue table. Update:11-30

    What is the best technique for dropping the High Water Mark on a queue table? Will the dbms_aqadm.purge_queue_table procedure drop the high water mark (truncate the queue table) when purging all records from the queue? If not, is it supported to manu

  • Error while dropping a table Update:10-11

    Hi All, i got an error while dropping a table which is ORA-00600: internal error code, arguments: [kghstack_free1], [kntgmvm: collst], [], [], [], [], [], [], [], [], [], [] i know learnt that -600 error is related to dba. now how to proceed. thanks

  • Dropping a table gives an error Update:10-11

    When I try to drop a table it gives the following error? SQL> drop table FLOWS_010600.SYS_IOT_OVER_55056; drop table FLOWS_010600.SYS_IOT_OVER_55056 ERROR at line 1: ORA-25191: cannot reference overflow table of an index-organized table what should i