ORA-26684: invalid value for value_type

Cause : The vlaue_tyep paraemter sohuld b eone o f'OLD' ,'NEW'o r '*'

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

Retryw ith porper vlaue_tyep.

update : 24-05-2017

ORA-26684 - invalid value for value_type
ORA-26684 - invalid value for value_type

  • ora-06813 : TLI Driver: the configured ethernet address is incorrect
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-14124 : duplicate REVERSE clause
  • ora-33082 : (XSAGDNGL41) In AGGMAP workspace object, the non-dimensioned valueset workspace object must have a parent QDR in its VALUESET statement over the VALUESET's base dimension.
  • ora-04940 : unsupported optimization of Oracle binary, check alert log for more info
  • ora-14057 : partition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-24414 : Only number sessions could be started.
  • ora-07607 : szaud: $SNDOPR failure
  • ora-00119 : invalid specification for system parameter string
  • ora-09986 : wrong number of bytes read from SGA definition file
  • ora-09820 : Conversion of class string to numeric representation failed.
  • ora-30770 : Cannot specify storage options for fixed size opaque type
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-13202 : failed to create or insert into the SDO_INDEX_METADATA table
  • ora-00084 : global area must be PGA, SGA, or UGA
  • ora-23303 : application raised generic exception during deferred RPC
  • ora-39083 : Object type string failed to create with error: string Failing sql is: string
  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-16728 : consistency check for property string found string error
  • ora-13485 : error occurred during compression or decompression: string
  • ora-02458 : HASHKEYS must be specified for a HASH CLUSTER
  • ora-06435 : ssaio: write error, unable to write requested block to database file.
  • ora-13144 : target table string not found
  • ora-28665 : table and partition must have same compression attribute
  • ora-12100 : materialized view log on "string"."string" already has sequence
  • ora-06040 : NETDNT: invalid login (connect) string
  • ora-02347 : cannot grant privileges on columns of an object table
  • ora-01854 : julian date must be between 1 and 5373484
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • 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.