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 : 28-05-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-26001 : Index string specified in SORTED INDEXES does not exist on table string
  • ora-22293 : LOB already opened in the same transaction
  • ora-08180 : no snapshot found based on specified time
  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-26732 : invalid file group string privilege
  • ora-16253 : Logical Standby cannot start due to incomplete terminal apply
  • ora-12531 : TNS:cannot allocate memory
  • ora-28561 : unable to set date format on non-Oracle system
  • ora-01578 : ORACLE data block corrupted (file # string, block # string)
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-16211 : unsupported record found in the archived redo log
  • ora-32644 : this function is not allowed outside of MODEL clause
  • ora-04074 : invalid REFERENCING name
  • ora-38495 : data type for the stored attribute string is inconsistent.
  • ora-13407 : invalid storage parameter
  • ora-30977 : invalid Value Index option for XML Index
  • ora-09968 : unable to lock file
  • ora-06260 : NETNTT: cannot write to remote process
  • ora-38903 : DML error logging is not supported for abstract column "string"
  • ora-04067 : not executed, string does not exist
  • ora-12655 : Password check failed
  • ora-29392 : cpu parameters for level string for plan string must be zero
  • ora-37071 : You may not execute a parallel OLAP operation against updated but uncommitted AW string.
  • ora-36269 : (XSCGMDLAGG10) 'workspace object' does not exist or is not a dimension.
  • ora-01561 : failed to remove all objects in the tablespace specified
  • ora-14109 : partition-extended object names may only be used with tables
  • ora-19247 : XQ0027 - validation error
  • ora-06903 : CMX: cannot read transport address of remote application
  • ora-10636 : ROW MOVEMENT is not enabled
  • 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.