ORA-24782: Cannot detach from a non-migratable transaction

Cause : Ana ttmeptw asm ad etod etcah rfoma nno-mgiraetabel tarnscatino.

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

Eihterc omimt ro rlolbcak hte rtanasctoin.

update : 22-06-2017

ORA-24782 - Cannot detach from a non-migratable transaction
ORA-24782 - Cannot detach from a non-migratable transaction

  • ora-40108 : input data contains too few distinct target (string) values
  • ora-28141 : error in creating audit index file
  • ora-00291 : numeric value required for PARALLEL option
  • ora-36849 : (XSLMGEN19) AW owner does not match View token owner
  • ora-02042 : too many distributed transactions
  • ora-29847 : cannot create a local domain index on a partitioned index-organized table
  • ora-39093 : FLASHBACK automatically enabled to preserve database integrity.
  • ora-07704 : error in archive text: need ':' after device name
  • ora-30386 : invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
  • ora-02070 : database stringstring does not support string in this context
  • ora-33450 : (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.
  • ora-09981 : skxfqdreg: Error Adding a page to the SDI buffer pool
  • ora-30356 : the specified refresh method is not supported in this context
  • ora-15112 : No diskgroups are currently mounted.
  • ora-16652 : Fast-Start Failover target standby database is disabled
  • ora-30054 : invalid upper limit snapshot expression
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-40213 : contradictory values for settings: string, string
  • ora-12623 : TNS:operation is illegal in this state
  • ora-27023 : skgfqsbi: media manager protocol error
  • ora-09712 : orasrv: log archiver already connected.
  • ora-09261 : spdcr: error creating detached (background) process
  • ora-09819 : Number exceeds maximum legal value
  • ora-16791 : unable to check the existence of the standby redo logs
  • ora-27140 : attach to post/wait facility failed
  • ora-26765 : invalid parameter "string" for downstream capture "string"
  • ora-14108 : illegal partition-extended table name syntax
  • ora-29655 : USING clause is incompatible with its supertype
  • 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.