-
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 ?
-
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|