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 : 23-05-2017
ORA-27467

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

  • ora-14505 : LOCAL option valid only for partitioned indexes
  • ora-16653 : failed to reinstate database
  • ora-22818 : subquery expressions not allowed here
  • ora-13425 : function not implemented
  • ora-31901 : the current operation was cancelled by the user
  • ora-13116 : [string]_FACE$ table does not exist
  • ora-13004 : the specified buffer size is invalid
  • ora-01877 : string is too long for internal buffer
  • ora-15108 : missing or invalid template name
  • ora-19586 : %s k-byte limit is too small to hold piece directory
  • ora-31499 : null value specified for required parameter string
  • ora-12547 : TNS:lost contact
  • ora-13467 : unsupported GeoRaster metadata specification: string
  • ora-30449 : syntax error in parameter string
  • ora-12423 : invalid position specified
  • ora-03217 : invalid option for alter of TEMPORARY TABLESPACE
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-31522 : could not find Streams object string for CDC change set string
  • ora-28663 : Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
  • ora-12608 : TNS: Send timeout occurred
  • ora-29348 : You must specify the datafiles to be plugged in
  • ora-19932 : control file is not clone or standby
  • ora-00267 : name of archived log file not needed
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-30743 : "string" is not an object view
  • ora-14189 : this physical attribute may not be specified for an index subpartition
  • ora-02052 : remote transaction failure at string
  • ora-25502 : concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running
  • ora-32136 : Cannot perform operation on an invalid stream
  • ora-39030 : invalid file type string
  • 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.