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-16032: parameter string destination string cannot be translated

1 Answers  


ORA-22320: missing user version string

1 Answers  


TNS-02516: No data available

1 Answers  


ORA-02162: invalid value for MAXDATAFILES

1 Answers  


ORA-23466: flavor requires missing object "string"."string"

1 Answers  


PCC-00098: Scale specification cannot be used in this context

1 Answers  


ORA-16019: cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

1 Answers  


ORA-23338: priority or value already in priority group string

1 Answers  


ORA-09280: sllfcf: error closing file

1 Answers  


RMAN-06146: changes found for file number beyond offline SCN

1 Answers  


RMAN-08500: channel string: sid=string devtype=string

1 Answers  


PLS-00335: a package name conflicts with an existing object

1 Answers  


Categories