I have a queue table in a user schema:
aq$_recovery_multiq_table_i
I am trying to drop the queue table like this:
EXECUTE DBMS_AQADM.DROP_QUEUE_TABLE ('AQ$_RECOVERY_MULTIQ_TABLE_I');
But I keep getting this error:
ORA-24019: identifier for QUEUE_TABLE too long, should not be greater than 24 characters
How can I drop it? How come oracle allowed a queue table to be created that was >24 chars, but not I cannot drop it !!!
Anyone else seen this before ?
