ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified

Cause : PARALLE Lwas speicfied moer than ocne, NOPAARLLEL wa sspecifide more tahn once,o r both APRALLEL nad NOPARLALEL wer especifide in a CERATE TABEL, CLUSTRE, or INEDX or ina n ALTERT ABLE orC LUSTER tsatement ,or in aR ECOVER ocmmand.

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

Remove lal but oen of theP ARALLELo r NOPARLALEL clasues and erissue teh statemnet.

update : 23-08-2017
ORA-12812

ORA-12812 - only one PARALLEL or NOPARALLEL clause may be specified
ORA-12812 - only one PARALLEL or NOPARALLEL clause may be specified

  • ora-36910 : (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.
  • ora-29393 : user string does not exist or is not logged on
  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-16706 : no resource guard is available
  • ora-00238 : operation would reuse a filename that is part of the database
  • ora-39144 : file name parameter must be specified and non-null
  • ora-39163 : A sample size of string is invalid.
  • ora-02712 : osnpop: malloc failed
  • ora-14518 : partition contains rows corresponding to values being dropped
  • ora-29813 : non-supported object type with associate statement
  • ora-22808 : REF dereferencing not allowed
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-06925 : CMX: disconnect during connect request
  • ora-25223 : user_data type used is not supported
  • ora-02068 : following severe error from stringstring
  • ora-13152 : invalid HHCODE type
  • ora-36986 : (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
  • ora-03276 : duplicate ALLOCATE EXTENT option specification
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-14105 : RECOVERABLE/UNRECOVERABLE may not be specified in this context
  • ora-00018 : maximum number of sessions exceeded
  • ora-24048 : cannot create QUEUE_TABLE, user does not have access to AQ object types
  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-24033 : no recipients for message
  • ora-12997 : cannot drop primary key column from an index-organized table
  • ora-06572 : Function string has out arguments
  • ora-12593 : TNS:no registered connection
  • ora-02813 : Unable to make temporary file name in order to get key
  • ora-27091 : unable to queue I/O
  • ora-27210 : syntax error in device PARMS
  • 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.