I have a queue table in a user schema:
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 ?
ORA-24019: identifier for QUEUE_TABLE too long, should not be greater than 24
You can rename the table and then try drop
alter table LONG_TABLE_NAME rename to SHORT_TBL;
Click Here to Expand Forum to Full Width