ORA-24072: cannot execute MIGRATE_QUEUE_TABLE procedure;
must own queue table



ORA-24072: cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table..

Answer / guest

Cause: An attempt was made to upgrade or downgrade a queue
table using the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure,
but the user who executed the procedure does not own the queue.

Action: Reconnect as the owner of the queue table, and then
execute the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00107: Invalid maximum number of discards

1 Answers  


NZE-29084: The parameter specified is illegal.

1 Answers  


ORA-19905: log_archive_format must contain %%s, %%t and %%r

2 Answers  


TNS-00010: Error while flushing NS context

1 Answers  


ORA-06977: X.25 Driver: X.25 Level 2 failure

1 Answers  






ORA-29837: insufficient privileges to execute implementation type

1 Answers  


RMAN-06180: incremental backups require Enterprise Edition

1 Answers  


RMAN-06503: skipping backupset key string; already backed up on string

1 Answers  


ORA-29876: failed in the execution of the ODCIINDEXDELETE routine

2 Answers  


ORA-12655: Password check failed

1 Answers  


RMAN-08509: destination for restore of datafile string: string

1 Answers  


PCB-00202: Indicator variable string not a group item or table

1 Answers  


Categories