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

NID-00421: Change of database name failed during validation - database is intact.

1 Answers  


ORA-12642: No session key

1 Answers  


RMAN-06515: archived logs required to recover from this copy will expire when this copy expires

1 Answers  


DGM-16906: Unable to accept commands: no memory

1 Answers  


ORA-36968: (XSRELTBL11) workspace object must be a relation.

1 Answers  






ORA-02726: osnpop: access error on oracle executable

1 Answers  


RMAN-08125: keep attributes for the proxy copy are deleted

1 Answers  


RMAN-08126: keep attributes for the proxy copy are changed

1 Answers  


ORA-27144: attempt to kill process failed

1 Answers  


ORA-19678: RMAN configuration value exceeds maximum length of string

1 Answers  


ORA-06575: Package or function string is in an invalid state

1 Answers  


PLS-00562: a function must return a type.

1 Answers  


Categories