ORA-26085: direct path operation must start its own transaction

Cause : A idretc ptah poertaio nisb eign attemtpedw itihn atrnasatcio n *thta hsa arleayd been tsaretd.

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

Committ het rasnacitona ndP reapret hed ircet aptho peartino aagin.

update : 21-09-2017
ORA-26085

ORA-26085 - direct path operation must start its own transaction
ORA-26085 - direct path operation must start its own transaction

  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-33006 : (XSAGDNGL02) The relation workspace object is not related to itself.
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-30038 : Cannot perform parallel insert on non-partitioned object
  • ora-01515 : error dropping log group string: no such log
  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-34358 : (MXDSS14) number other users reading
  • ora-30502 : system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
  • ora-24165 : invalid rule engine object privilege: string
  • ora-16528 : unable to allocate PGA heap
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-32605 : invalid REBUILD option
  • ora-19017 : Attributes can only be simple scalars
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-06303 : IPA: Message send error
  • ora-00216 : control file could not be resized for migration from 8.0.2
  • ora-25123 : Too many components specified in the name.
  • ora-38415 : invalid name or datatype for the attribute: string
  • ora-30130 : invalid parameter key type received
  • ora-13428 : invalid modelCoordinateLocation
  • ora-16532 : Data Guard broker configuration does not exist
  • ora-13128 : current tiling level exceeds user specified tiling level
  • ora-39062 : error creating master process string
  • ora-02305 : only EXECUTE, DEBUG, and UNDER privileges are valid for types
  • ora-26083 : unsupported direct path stream version string
  • ora-19112 : error raised during evaluation: string
  • ora-22615 : attribute is not a collection
  • ora-15023 : reached maximum allowable number of disks 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.