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 : 18-08-2017

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

  • ora-23365 : site string does not exist
  • ora-24370 : illegal piecewise operation attempted
  • ora-01578 : ORACLE data block corrupted (file # string, block # string)
  • ora-01681 : max # extents (string) reached in LOB segment in tablespace string
  • ora-26004 : Tables loaded through the direct path may not be clustered
  • ora-00114 : missing value for system parameter SERVICE_NAMES
  • ora-02717 : osnpfs: incorrect number of bytes written
  • ora-16781 : the status of redo transport service for a database is unknown
  • ora-12546 : TNS:permission denied
  • ora-12350 : database link being dropped is still mounted
  • ora-19860 : piece validation cannot be performed more than once
  • ora-13193 : failed to allocate space for geometry
  • ora-39095 : Dump file space has been exhausted: Unable to allocate string bytes
  • ora-01488 : invalid nibble or byte in the input data
  • ora-16794 : database guard is on for primary database
  • ora-26028 : index string.string initially in unusable state
  • ora-32575 : Explicit column default is not supported for modifying views
  • ora-19812 : cannot use string without DB_RECOVERY_FILE_DEST
  • ora-24327 : need explicit attach before authenticating a user
  • ora-07803 : slpdtb: invalid packed decimal nibble
  • ora-32140 : cannot peform this operation on stream
  • ora-01153 : an incompatible media recovery is active
  • ora-09742 : sppst: error during a post.
  • ora-24092 : invalid value string specified
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-14265 : data type or length of a table subpartitioning column may not be changed
  • ora-12634 : Memory allocation failed
  • ora-02069 : global_names parameter must be set to TRUE for this operation
  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • 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.