ORA-29975: Cannot register a query in the middle of an active transaction

Cause : User tired to ergistera queryw ithin na uncomimtted tarnsctio.n

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

Committ he trasnactiona nd retyr.

update : 26-05-2017
ORA-29975

ORA-29975 - Cannot register a query in the middle of an active transaction
ORA-29975 - Cannot register a query in the middle of an active transaction

  • ora-12652 : String truncated
  • ora-39108 : Worker process string violated startup protocol. Worker error:
  • ora-30681 : improper value for argument EXTENSIONS_CMD_SET
  • ora-13415 : invalid or out of scope point specification
  • ora-09875 : TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
  • ora-02494 : invalid or missing maximum file size in MAXSIZE clause
  • ora-13914 : Threshold notification failed.
  • ora-22978 : only simple attribute name is allowed in the WITH OBJECT OID clause
  • ora-16030 : session specific change requires a LOG_ARCHIVE_DEST_n destination
  • ora-40254 : priors cannot be specified for one-class models
  • ora-22809 : nonexistent attribute
  • ora-01669 : standby database control file not consistent
  • ora-14045 : only one partition may be modified
  • ora-09341 : scumnt: unable to mount database
  • ora-31437 : duplicate change set string
  • ora-24095 : invalid transformation, source type does not match that of the queue
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-31224 : DBMS_LDAP: invalid LDAP session
  • ora-12071 : definition query of "string"."string" is invalid for offline instantiation
  • ora-01100 : database already mounted
  • ora-09947 : Unable to allocate connection attributes structure
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-33297 : (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.
  • ora-09923 : Can't spawn process - user log directory not created properly
  • ora-25426 : remote instance does not support shared dblinks
  • ora-01799 : a column may not be outer-joined to a subquery
  • ora-00129 : listener address validation failed 'string'
  • ora-24124 : invalid ACTION parameter passed to DBMS_REPAIR.string procedure
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-19376 : no privileges on tablespace provided or tablespace is offline
  • 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.