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-06-2017
ORA-27467

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

  • ora-26102 : relative file # in file header is string rather than string for file string
  • ora-27100 : shared memory realm already exists
  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-22801 : invalid object row variable
  • ora-23372 : type string in table string is unsupported
  • ora-30566 : Index maintainence clause not allowed for this command
  • ora-28342 : integrity check fails on column key
  • ora-02182 : savepoint name expected
  • ora-01982 : invalid auditing option for tables
  • ora-23538 : cannot explicitly refresh a NEVER REFRESH materialized view ("string")
  • ora-06745 : TLI Driver: listener already running
  • ora-30025 : DROP segment 'string' (in undo tablespace) not allowed
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-37043 : (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.
  • ora-12600 : TNS: string open failed
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-25294 : Cannot propagate user buffered messages to a database with version lower than 10.2
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-07672 : $PARSE_CLASS failed translating the string into a binary label
  • ora-34841 : (OPCREATE02) The string option must be declared with the READONLY attribute.
  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-12548 : TNS:incomplete read or write
  • ora-32818 : AQ queue string does not exist
  • ora-29874 : warning in the execution of ODCIINDEXALTER routine
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-37182 : you may only specify one dimension to partition
  • ora-16229 : PDML child string string string for parent string string string cannot be skipped.
  • ora-01325 : archive log mode must be enabled to build into the logstream
  • 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.