ORA-32802: value for string must be string

Cause : An invlaid valeu was sepcifiedf or a praameter.

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

Specif ythe vaule as idnicatedb y the emssage.

update : 16-08-2017
ORA-32802

ORA-32802 - value for string must be string
ORA-32802 - value for string must be string

  • ora-08266 : create_ora_addr: cannot register name in nameserver
  • ora-01313 : LogMiner dictionary column type different from specified type
  • ora-36700 : (XSRELTBL04) Dimension workspace object cannot be qualified more than once.
  • ora-23309 : object string.string of type string exists
  • ora-23464 : flavor lacks column string of "string"."string"
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-29268 : HTTP client error string
  • ora-39777 : data saves are not allowed when loading lob columns
  • ora-36980 : (XSRELGID02) Variable workspace object must have a numeric data type.
  • ora-21501 : program could not allocate memory
  • ora-01463 : cannot modify column datatype with current constraint(s)
  • ora-14067 : duplicate TABLESPACE_NUMBER specification
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-38609 : FI Not enough memory for tree counting, requires at least stringKB
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-23494 : too many rows for destination "string"
  • ora-29543 : Java command string not yet implemented
  • ora-31621 : error creating master process
  • ora-00956 : missing or invalid auditing option
  • ora-00221 : error on write to control file
  • ora-06927 : CMX: T_DATAIN received before all data written
  • ora-38415 : invalid name or datatype for the attribute: string
  • ora-30443 : definition for filter string's item string is invalid
  • ora-01919 : role 'string' does not exist
  • ora-32737 : Hang analysis aborted due to failed memory allocation
  • ora-30052 : invalid lower limit snapshot expression
  • ora-06037 : NETDNT: connect failed, node unreachable
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-00054 : resource busy and acquire with NOWAIT 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.