ORA-12841: Cannot alter the session parallel DML state within a transaction

Cause : rTnaastcoi nnip orrgses

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

oCmmtio rorllabkct arsncaitnoa dnt eh nere-exucet

update : 30-04-2017
ORA-12841

ORA-12841 - Cannot alter the session parallel DML state within a transaction
ORA-12841 - Cannot alter the session parallel DML state within a transaction

  • ora-16402 : ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support
  • ora-01955 : DEFAULT ROLE 'string' not granted to user
  • ora-25106 : only one of PARALLEL or NOPARALLEL clause may be specified
  • ora-06911 : CMX: t_event returns ERROR
  • ora-08210 : Requested I/O error
  • ora-12827 : insufficient parallel query slaves available
  • ora-39201 : Dump files are not supported for estimate only jobs.
  • ora-37080 : Advice requested for hierarchy with too many levels
  • ora-25139 : invalid option for CREATE TEMPORARY TABLESPACE
  • ora-26061 : Concurrent direct unloads is not allowed.
  • ora-24365 : error in character conversion
  • ora-12850 : Could not allocate slaves on all specified instances: string needed, string allocated
  • ora-39313 : call to DBMS_SCHEMA_COPY.CLONE is not legal
  • ora-38472 : VARCHAR representation of the data item is too long.
  • ora-24336 : invalid result set descriptor
  • ora-30569 : data type of given column is not supported in a log group
  • ora-01490 : invalid ANALYZE command
  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-36666 : (XSDPART04) workspace object is not a concat dimension.
  • ora-16008 : indeterminate control file checkpoint
  • ora-00381 : cannot use both new and old parameters for buffer cache size specification
  • ora-24410 : scrollable cursor max size exceeded
  • ora-14085 : partitioned table cannot have column with LONG datatype
  • ora-36952 : (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.
  • ora-14614 : List value 'string' specified twice in subpartition 'string'
  • ora-16240 : Waiting for logfile (thread# string, sequence# string)
  • ora-09808 : Could not obtain user clearance.
  • ora-01232 : cannot start online backup - file string is being made read-only
  • ora-22610 : error while adding a scalar to the image handle
  • ora-07410 : slpdtb: number too large for supplied buffer.
  • 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.