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-09-2017

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-13613 : The requested operation is not supported for this advisor object.
  • ora-14032 : partition bound of partition number string is too high
  • ora-16005 : database requires recovery
  • ora-31157 : Invalid Content-Type charset
  • ora-38756 : Flashback is already turned off for this tablespace.
  • ora-13773 : insufficient privileges to select data from the cursor cache
  • ora-19323 : Invalid url string
  • ora-15090 : handle string is not a valid descriptor
  • ora-24191 : the property name string has existed
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-30447 : internal data for run number string is inconsistent
  • ora-00060 : deadlock detected while waiting for resource
  • ora-32117 : Source LOB is null
  • ora-16605 : unable to delete template, template is in use
  • ora-25106 : only one of PARALLEL or NOPARALLEL clause may be specified
  • ora-32805 : identifier for string too long, maximum length is string characters
  • ora-27032 : failed to obtain file size limit
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • ora-31111 : table string cannot be hierarchically enabled
  • ora-14172 : invalid ALTER TABLE EXCHANGE SUBPARTITION option
  • ora-39156 : error parsing dump file name "string"
  • ora-33070 : (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.
  • ora-30726 : cannot specify referenced column list here
  • ora-13158 : Oracle object string does not exist
  • ora-01478 : array bind may not include any LONG columns
  • ora-23427 : deferred purge queue argument string out of range
  • ora-12807 : process queue could not receive parallel query message
  • ora-36341 : (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)
  • ora-07549 : sftopn: $OPEN failure
  • ora-02058 : no prepared transaction found with ID string
  • 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.