ORA-12820: invalid value for DEGREE

Cause : invalid value for DEGREE was specified within a PARALLEL clause.

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

specify a positive integer or DEFAULT for the DEGREE option within a PARALLEL clause.

update : 19-08-2017

ORA-12820 - invalid value for DEGREE
ORA-12820 - invalid value for DEGREE

  • ora-01633 : Real Application Clusters Option needed for this operation
  • ora-06256 : NETNTT: remote fork failed
  • ora-29274 : fixed-width multibyte character set not allowed for a URL
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-00287 : specified change number string not found in thread string
  • ora-07656 : slsprom:$GETDVI failure
  • ora-10664 : Table has bitmap join indexes
  • ora-00336 : log file size string blocks is less than minimum string blocks
  • ora-29516 : Aurora assertion failure: string
  • ora-30177 : invalid flag used in a format specification
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-02426 : privilege grant failed
  • ora-27209 : syntax error in device PARMS - unknown keyword or missing =
  • ora-01635 : rollback segment #string specified not available
  • ora-31413 : change set string is currently being advanced
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-31634 : job already exists
  • ora-37174 : source SQL must be a SELECT statement
  • ora-00827 : could not shrink sga_target to specified value
  • ora-14115 : partition bound of partition number string is too long
  • ora-31071 : Invalid database username or GUID string
  • ora-31503 : invalid date supplied for begin_date or end_date
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-12341 : maximum number of open mounts exceeded
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-29396 : cannot switch group to string
  • ora-24786 : separated transaction has been completed
  • ora-30000 : missing either trim specification or char expression in TRIM
  • ora-14193 : invalid ALTER INDEX MODIFY SUBPARTITION option
  • ora-29364 : plan directive string, string already exists
  • 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.