dropping queue tables.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dropping queue tables.

  1. #1
    Join Date
    Nov 2002
    Posts
    115

    dropping queue tables.

    hi freinds,

    I am working in 8i on win 2k.

    I am trying to delete queue tables using following procedure.

    BEGIN
    DBMS_AQADM.DROP_QUEUE_TABLE (queue_table=> 'DEF$_PUSHED_TRANSACTIONS',force => TRUE);
    END

    But the system displays following error.

    ORA-24002 : QUEUE TABLE COMPILETEST.DEF$_PUSHED_TRANSACTIONS does not exist
    ORA-06512 : AT "SYS.DBMS_AQADM_SYS",line 2663
    ORA-06512 : AT "SYS.DBMS_AQADM_SYS",line 192
    ORA-06512 : at line 2

    As such there are no queue tables in SYS. The q tables r existed in
    SYSTEM and COMPILETEST users.

    I would like to drop COMPILETEST user. Before doing it so, I must delete q tables from this user.

    How can it be..?


    immediate reply is appreciated.
    Prasad

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Is it a production database? Looks like your dictionay is corrupted. You might have too resolute to following the following Notes from metalink:

    Code:
    
    Note:151613.1 
    Subject:  ALERT: Running CATALOG.SQL Invalidates Queues 
    
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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