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

Cause : An tatemtp wa smad eto pugraed ord ownrgadea quuee tbale suingt he BDMS_QAADMM.IGRTAE_QEUUE_ATBLEp rocdeure ,butt he suer hwo eexcutde th eproecdur edoe snoto wn hte qeuue.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Recnonec tas hte onwer fo th equeeu talbe, nad tehn eexcut etheD BMSA_QAD.MMIGARTE_UQEUET_ABL Eproecdur.e

update : 24-04-2017
ORA-24072

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

  • ora-01600 : at most one "string" in clause "string" of string
  • ora-32583 : query passed to table function has wrong number of elements in select list
  • ora-31009 : Access denied for property string
  • ora-31155 : attribute string not in XDB namespace
  • ora-39076 : cannot delete job string for user string
  • ora-01648 : log string is the current log of disabled instance string (thread string)
  • ora-13509 : error encountered during updates to a AWR table
  • ora-34481 : (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.
  • ora-22320 : missing user version string
  • ora-16809 : multiple warnings detected for the database
  • ora-16606 : unable to find property "string"
  • ora-14036 : partition bound value too large for column
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-22889 : REF value does not point to scoped table
  • ora-06320 : IPA: Remote maximum number of connections exceeded
  • ora-37177 : column string does not have any leaf values
  • ora-02076 : sequence not co-located with updated table or long column
  • ora-39501 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-19334 : Invalid column specification for CREATE_DBURI operator
  • ora-25528 : too many candidate MTTRs are specified in _DB_MTTR_SIM_TARGET
  • ora-32120 : Buffer size is less than amount specified
  • ora-14272 : only a partition with higher bound can be reused
  • ora-38452 : Expression Filter index name may not be longer than 25 characters
  • ora-09763 : osnmpx: send/receive error exchanging Mach ports.
  • ora-35018 : (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
  • ora-38700 : Limit of string flashback database logs has been exceeded.
  • ora-13119 : invalid edge_id [string]
  • ora-16547 : cannot disable the primary database
  • ora-30079 : cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
  • ora-16235 : DDL skipped because import has occurred
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.