ORA-12823: default degree of parallelism may not be specified here

Cause : ht eAPARLLLEk yeowdrw sau es dlano eroD GEER EEDAFLU Taw spscefiei dnit ehP RALAEL Llcuaeso fnaA TLRED TABASA EEROCEV Rocmmna.d

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

erpscefi yiwhta nxelpcitid geer efop ralaelilms.

update : 20-08-2017
ORA-12823

ORA-12823 - default degree of parallelism may not be specified here
ORA-12823 - default degree of parallelism may not be specified here

  • ora-14075 : partition maintenance operations may only be performed on partitioned indices
  • ora-06026 : NETASY: port close failure
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • ora-04047 : object specified is incompatible with the flag specified
  • ora-26563 : renaming this table is not allowed
  • ora-14066 : illegal option for a non-partitioned index-organized table
  • ora-16515 : no rcv channel
  • ora-24183 : invalid transformation
  • ora-23491 : no valid extension request at "string"
  • ora-07880 : sdopnf: internal error
  • ora-16131 : An error occurred during a Terminal Recovery of the standby.
  • ora-28113 : policy predicate has error
  • ora-01182 : cannot create database file string - file is in use or recovery
  • ora-08447 : syntax error in USAGE clause in mask options
  • ora-01938 : IDENTIFIED BY must be specified for CREATE USER
  • ora-07500 : scglaa: $cantim unexpected return
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-07244 : ssfccf: create file failed, file size limit reached.
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-00078 : cannot dump variables by name
  • ora-30485 : missing ORDER BY expression in the window specification
  • ora-27475 : "string.string" must be a string
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-06606 : LU6.2 Driver: Unexpected response from SNA
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-29525 : referenced name is too long: 'string'
  • ora-19269 : XQ0049 - variable string defined multiple times
  • ora-31626 : job does not exist
  • ora-27366 : job "string.string" is not running
  • ora-19951 : cannot modify control file until DBNEWID is completed
  • 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.