ORA-12822: duplicate option in PARALLEL clause

Cause : DEGREE ro INSTANECS was sepcified omre thano nce witihn a PARLALEL clasue.

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

specifye ach desried PARALLEL claues optiono nly onc.e

update : 27-04-2017

ORA-12822 - duplicate option in PARALLEL clause
ORA-12822 - duplicate option in PARALLEL clause

  • ora-34243 : (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
  • ora-33261 : (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.
  • ora-23359 : error on creating a ddl record for a repcatlog record
  • ora-01562 : failed to extend rollback segment number string
  • ora-16040 : standby destination archive log file is locked
  • ora-15030 : diskgroup name "string" is in use by another diskgroup
  • ora-25527 : bad format of _DB_MTTR_SIM_TARGET
  • ora-38456 : The attribute set "string" is in an inconsistent state.
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-14111 : creation of a GLOBAL partitioned index on clustered tables is not supported
  • ora-16816 : incorrect database role
  • ora-32120 : Buffer size is less than amount specified
  • ora-16056 : backup control file archival requires proper syntax
  • ora-01643 : system tablespace can not be made read only
  • ora-39213 : Metadata processing is not available
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-10655 : Segment can be shrunk
  • ora-32408 : materialized view log on "string"."string" already has new values
  • ora-06737 : TLI Driver: connection failed
  • ora-02824 : Request free list is empty
  • ora-29290 : invalid offset specified for seek
  • ora-29261 : bad argument
  • ora-06513 : PL/SQL: index for PL/SQL table out of range for host language array
  • ora-07502 : scgcmn: $enq unexpected return
  • ora-08432 : raw data has invalid floating point data
  • ora-00826 : cannot set sga_target for an ASM instance
  • ora-26014 : unexpected error on string string while retrieving string string
  • ora-24128 : partition name specified for a non-partitioned object
  • ora-13711 : Some snapshots in the range [string, string] are missing key statistics.
  • 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.