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 : 25-06-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-40290 : model incompatible with data mining function
  • ora-31444 : parameter error while acquiring lock on string
  • ora-08318 : sllfsk: Error reading file
  • ora-12045 : invalid ALTER MATERIALIZED VIEW LOG option
  • ora-02814 : Unable to get shared memory
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-17501 : logical block size string is invalid
  • ora-29314 : tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY
  • ora-13035 : Invalid data (arcs in geodetic data) in the SDO_GEOMETRY object
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • ora-00339 : archived log does not contain any redo
  • ora-24396 : invalid attribute set in server handle
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-16220 : no failed transaction found
  • ora-37129 : (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-06958 : Failed to access configuration file
  • ora-13148 : failed to generate SQL filter
  • ora-14070 : option may be specified only for partitioned indices or with REBUILD
  • ora-35016 : (QFCHECK00) The analytic workspace and EIF file definitions of workspace object have a mismatched type.
  • ora-15104 : conflicting CONTENTS options
  • ora-28272 : Domain policy restricts password based GLOBAL user authentication.
  • ora-21612 : key is already being used
  • ora-24017 : cannot enable enqueue on QUEUE, string is an exception queue
  • ora-13200 : internal error [string] in spatial indexing.
  • ora-01532 : cannot create database; instance being started elsewhere
  • ora-16761 : resource guard could not stop SQL Apply
  • ora-13127 : failed to generate target partition
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-27459 : A program of type EXECUTABLE must have character-only arguments.
  • ora-09911 : Incorrect user password.
  • 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.