DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dropping AQ table (Urgent)

  1. #1
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Hi


    SQL> exec dbms_aqadm.drop_queue_table('AQ$_QTABLE');
    BEGIN dbms_aqadm.drop_queue_table('AQ$_QTABLE');
    END;

    *
    ERROR at line 1:
    ORA-24012: cannot drop QUEUE_TABLE, some queues in TEST.AQ$_QTABLE have not
    been dropped
    ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2670
    ORA-06512: at "SYS.DBMS_AQADM", line 192
    ORA-06512: at line 1

    hOW TO DROP this AQ table.

    Reply urgent

    Paresh

  2. #2
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Hi All,

    How will I find Queue Name in my database

    Also I want to know how to drop the MQ table.

    Thanks

    Paresh

  3. #3
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    You can check the Q's under your schema by viewing user_queues object.
    If you want to drop the q table, first you have to stop the q and drop the q table.

    Good Luck.
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width