Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Drop queue_table

suman amaraSep 12 2014 — edited Sep 15 2014

hi Team,

I am dropping queue table i am getting below error ..

BEGIN


   DBMS_AQADM.DROP_QUEUE_TABLE(QUEUE_TABLE => 'AQ$.QT_GIFT_REDEMPTIONS_S', FORCE => TRUE);


END;


/

    

Error report -

ORA-24002: QUEUE_TABLE AQ$.QT_GIFT_REDEMPTIONS_S does not exist

ORA-06512: at "SYS.DBMS_AQADM", line 240

ORA-06512: at line 2

24002. 00000 -  "QUEUE_TABLE %s does not exist"

*Cause:    Queue_table not exist.

*Action:   Query on the user view USER_QUEUE_TABLES to find out existing queue

           tables.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 13 2014
Added on Sep 12 2014
#advanced-queueing, #database-key-features
8 comments
3,116 views