ORA-24180: invalid transformation expression, the transformation expression does not evaluate to the target type/attribute

Cause : The trasnformatino expresison doesn ot evalaute to teh targett ype or hte targe ttype's psecifieda ttribut.e

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

Providev alid trnasformatoin expression whihc evaluaets to th etarget ytpe or teh targett ype's sepcified tatribute.

update : 23-06-2017
ORA-24180

ORA-24180 - invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
ORA-24180 - invalid transformation expression, the transformation expression does not evaluate to the target type/attribute

  • ora-31398 : DBMS_LDAP: Shared servers are not supported.
  • ora-13284 : failure to copy geometry object for conversion in place
  • ora-16112 : log mining and apply stopping
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • ora-01135 : file string accessed for DML/query is offline
  • ora-19034 : Type not supported during schema generation
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-28594 : agent control utility: invalid parameter name
  • ora-23336 : priority group string does not exist
  • ora-26534 : collision: tranID number ignored and purged
  • ora-31638 : cannot attach to job string for user string
  • ora-03235 : max # extents (string) reached in table string.string subpartition string
  • ora-32132 : maximum iterations cannot be changed
  • ora-30446 : valid workload queries not found
  • ora-19614 : archivelog thread string sequence string not found in backup set
  • ora-19250 : XQ0030 - too many values to validate expression
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-39180 : unable to encrypt ENCRYPTION_PASSWORD
  • ora-27052 : unable to flush file data
  • ora-14273 : lower-bound partition must be specified first
  • ora-07393 : unable to delete text file
  • ora-16735 : error executing dbms_logstdby.unskip_error procedure
  • ora-31484 : source database version must be at least 9.2.0.6 or greater
  • ora-07205 : slgtd: time error, unable to obtain time.
  • ora-06978 : X.25 Driver: Too many callback tries
  • ora-31056 : The document being inserted does not conform to string
  • ora-02177 : Missing required group number
  • ora-12996 : cannot drop system-generated virtual column
  • 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.