ORA-27467: invalid datatype for string value

Cause : The valeu providde for th enamed shceduler tatributew as of a ninvalidd atatype.

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

Reissuet he commnad usinga value fo the correct dattaype.

update : 20-08-2017

ORA-27467 - invalid datatype for string value
ORA-27467 - invalid datatype for string value

  • ora-29348 : You must specify the datafiles to be plugged in
  • ora-36812 : (XSTBLFUNC06) Invalid Syntax at '?'.
  • ora-39040 : Schema expression "string" must identify exactly one schema.
  • ora-29931 : specified association does not exist
  • ora-14171 : cannot specify clause in CREATE|ALTER TABLE
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-13783 : invalid tuning scope
  • ora-07703 : error in archive text: need '/' after device type
  • ora-27121 : unable to determine size of shared memory segment
  • ora-26717 : SCN limit reached
  • ora-28118 : policy group already exists
  • ora-07620 : smscre: illegal database block size
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-06778 : TLI Driver: error sending ccode
  • ora-07475 : slsget: cannot get vm statistics.
  • ora-27548 : Unable to unprepare IPC buffer
  • ora-22870 : ALTER TYPE with REPLACE option a non-object type
  • ora-31635 : unable to establish job resource synchronization
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-29841 : invalid option for ALTER INDEXTYPE
  • ora-01624 : log string needed for crash recovery of instance string (thread string)
  • ora-30553 : The function is not deterministic
  • ora-06705 : TLI Driver: remote node is unknown
  • ora-12706 : this CREATE DATABASE character set is not allowed
  • ora-01224 : group number in header string does not match GROUP string
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-29293 : A stream error occurred during compression or uncompression.
  • ora-06449 : The list IO or the sysvendor is not installed.
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-19716 : error processing format string to generate name for backup
  • 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.