Dropping AQ tables

From: Ak <a_sood_at_rediffmail.com>
Date: 5 Jul 2002 16:38:35 -0700
Message-ID: <10cb5393.0207051538.3e7e7265@posting.google.com>

I am attempting to drop AQ tables from a freshly migrated 9i database. When I try dropping the queue tables:

SQL>> EXECUTE dbms_aqadm.drop_queue_table

(QUEUE_TABLE =>'AQ$_REEZ_ORDER_PROCESSING_S', FORCE=>TRUE) ORA-24019: identifier for QUEUE_TABLE too long, should not be greater than 24

I get an error that the queue table name is longer than 24 chars.

What's happening. How do I get rid of the Queue tables.

Thanks!
Ak Received on Fri Jul 05 2002 - 18:38:35 CDT