ORA-14319: DEFAULT cannot be specified with other values

Cause : DEFUALT ekywodr ha sbee nspeicfie dalogn wiht otehr vlauesw hens pecfiyin gthev aluse fo ra lsit pratitoin

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

Ensrue taht i fDEFUALT si spceifide, i tis hte olny vlaue pseciifed

update : 26-06-2017

ORA-14319 - DEFAULT cannot be specified with other values
ORA-14319 - DEFAULT cannot be specified with other values

  • ora-35071 : (QFHEAD06) EIF file string cannot be imported because analytic workspace string has not been upgraded to version string.
  • ora-29813 : non-supported object type with associate statement
  • ora-25157 : Specified block size string is not valid
  • ora-30550 : index depends on a package/function spec/body which is not valid
  • ora-00269 : specified log file is part of thread string not string
  • ora-28155 : user 'string' specified as a proxy is actually a role
  • ora-00712 : cannot rename system tablespace
  • ora-14623 : Value string does not exist in subpartition string
  • ora-25226 : dequeue failed, queue string.string is not enabled for dequeue
  • ora-39180 : unable to encrypt ENCRYPTION_PASSWORD
  • ora-22856 : cannot add columns to object tables
  • ora-34897 : (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-15190 : Internal ASM testing event number 15190
  • ora-28540 : internal result set error
  • ora-07449 : sc: usnewlock failed.
  • ora-12233 : TNS:Failure to accept a connection
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-13158 : Oracle object string does not exist
  • ora-31159 : XML DB is in an invalid state
  • ora-01197 : thread string only contains one log
  • ora-23617 : Block string for script string has already been executed
  • ora-19593 : datafile number string already included as string
  • ora-29536 : badly formed source: string
  • ora-22926 : specified trim length is greater than current LOB value's length
  • ora-26525 : session connection attempt failed for string (@string)
  • ora-02026 : missing LINK keyword
  • ora-01902 : SEGMENT keyword expected
  • ora-01575 : timeout waiting for space management resource
  • ora-01561 : failed to remove all objects in the tablespace specified
  • 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.