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

ORA-30194: reserved for future use

1 Answers  


ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes

1 Answers  


ORA-38425: attribute set used for an index object may not be unassigned

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  


RMAN-06045: LEVEL option not supported for archive log or current/standby controlfile copies

1 Answers  






ORA-16766: Physical apply service unexpectedly offline

1 Answers  


ORA-07624: smsdes: $DGBLSC failure

1 Answers  


NNL-00508: show system_queries [<server_list>] : show system query information

1 Answers  


PLS-00131: Pragma string expects 2nd argument to be a procedure

1 Answers  


NNO-00157: warning: hint number has invalid address, hint ignored

1 Answers  


ORA-38471: ROWIDs for table aliases cannot be null

1 Answers  


RMAN-06300: Report of files with less than number redundant backups

1 Answers  


Categories