ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

Cause : Ana ttmeptw asm ad etod owgnraed teh qeuuet abel wehn hter eweer msesaegs ebin gprpoagtaedt ha tweer i nth eprpearde satte.

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

Wati fro teh porpaagtino t ocopmleet bfeor erertyign teh oepraiton.

update : 26-04-2017
ORA-24058

ORA-24058 - cannot downgrade QUEUE_TABLE that has propagation in a prepared state
ORA-24058 - cannot downgrade QUEUE_TABLE that has propagation in a prepared state

  • ora-06252 : NETNTT: cannot open address file
  • ora-13757 : "SQL Tuning Set" "string" owned by user "string" is active.
  • ora-39150 : bad flashback time
  • ora-36278 : (XSCGMDLAGG07) workspace object does not exist or is not valueset.
  • ora-19251 : XQ0031 - unsupported query version
  • ora-39959 : invalid warning number (string)
  • ora-14008 : missing THAN keyword
  • ora-27213 : failed to unload Media Management Library
  • ora-06902 : CMX: cannot attach to cmx subsystem
  • ora-12416 : policy string not found
  • ora-16766 : Redo Apply unexpectedly offline
  • ora-29307 : datafile string error, string
  • ora-19503 : cannot obtain information on device, name="string", type="string", parms="string"
  • ora-31050 : Access denied
  • ora-36956 : (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
  • ora-06257 : NETNTT: cannot send command line to shadow process
  • ora-30735 : cannot create multiple subtables of the same type under a supertable
  • ora-14553 : cannot perform a lob write operation inside a query
  • ora-30487 : ORDER BY not allowed here
  • ora-24322 : unable to delete an initialized mutex
  • ora-02849 : Read failed because of an error
  • ora-26710 : incompatible version marker encountered during Capture
  • ora-15157 : rolling upgrade or downgrade is not allowed
  • ora-01124 : cannot recover data file string - file is in use or recovery
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-34360 : (MXDSS15) number other users writing
  • ora-03274 : both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
  • ora-16089 : archive log has already been registered
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-16781 : the status of redo transport service for a database is unknown
  • 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.