ORA-24785: Cannot resume a non-migratable transaction

Cause : An attempt was made to resume a non-migrateable transaction.

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

none

update : 26-05-2017
ORA-24785

ORA-24785 - Cannot resume a non-migratable transaction
ORA-24785 - Cannot resume a non-migratable transaction

  • ora-23372 : type string in table string is unsupported
  • ora-12004 : REFRESH FAST cannot be used for materialized view "string"."string"
  • ora-14315 : cannot merge a partition with itself
  • ora-38756 : Flashback is already turned off for this tablespace.
  • ora-36179 : (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.
  • ora-12044 : invalid CREATE MATERIALIZED VIEW LOG option
  • ora-01374 : _log_parallelism_max greater than 1 not supported in this release
  • ora-24952 : register, unregister or post has incorrect collection count
  • ora-26564 : %s argument is not of specified type
  • ora-06905 : CMX: connect error
  • ora-06134 : NETTCP: file access privilege violation
  • ora-31456 : error executing a procedure in the DBMS_CDC_UTILITY package
  • ora-01579 : write error occurred during recovery
  • ora-33445 : (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
  • ora-01898 : too many precision specifiers
  • ora-06033 : NETDNT: connect failed, partner rejected connection
  • ora-14606 : Tablespace was specified for previous subpartitions in template but is not specified for string
  • ora-07484 : snlkput: cannot convert(put) lock.
  • ora-29506 : invalid query derived from USING clause
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-01097 : cannot shutdown while in a transaction - commit or rollback first
  • ora-31640 : unable to open dump file "string" for read
  • ora-13154 : invalid precision specified
  • ora-24165 : invalid rule engine object privilege: string
  • ora-02286 : no options specified for ALTER SEQUENCE
  • ora-24755 : OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
  • ora-19000 : missing RELATIONAL keyword
  • ora-04051 : user string cannot use database link string.string
  • ora-36804 : (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP.
  • ora-07286 : sksagdi: cannot obtain device information.
  • 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.