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 : 24-04-2017

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

  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-30071 : conversion between datetime/interval and string fail
  • ora-12002 : there is no materialized view log on table "string"."string"
  • ora-00349 : failure obtaining block size for 'string'
  • ora-15180 : Could not open dynamic library string, error [string]
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-39952 : only numbers can be specified as range values
  • ora-25120 : MINIMUM EXTENT option already specified
  • ora-24173 : nested query not supported for rule condition
  • ora-25292 : Buffer operations are not supported on the queue
  • ora-19124 : fn:one-or-more() called with a sequence containing no items
  • ora-00058 : DB_BLOCK_SIZE must be string to mount this database (not string)
  • ora-30939 : Order violation: Element 'string' may not follow element 'string'
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • ora-38431 : could not evaluate subexpression "string" for rowid "string"
  • ora-09877 : sstascre: shmget error, unable to get a shared memory segment.
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-24350 : OCI call not allowed
  • ora-04089 : cannot create triggers on objects owned by SYS
  • ora-39107 : Master process string violated startup protocol. Master error:
  • ora-28364 : invalid wallet operation
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-27215 : skgfgsmcs: sbtinfo2 returned unknown file
  • ora-16068 : redo log file activation identifier mismatch
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-21709 : cannot refresh an object that has been modified
  • ora-16579 : bad Data Guard NetSlave state detected
  • ora-39179 : unable to load table "string"."string" because of OID transform
  • ora-01422 : exact fetch returns more than requested number of rows
  • ora-30736 : objects in a table or view hierarchy have to be in the same schema
  • 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.