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-04-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-30564 : Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
  • ora-02235 : this table logs changes to another table already
  • ora-15092 : I/O request size string is not a multiple of logical block size string
  • ora-19330 : Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator
  • ora-19653 : cannot switch to older file incarnation
  • ora-12854 : Parallel query is not supported on temporary LOBs
  • ora-35074 : (QFHEAD02) EIF file string cannot be read by this version of string.
  • ora-25132 : UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-24807 : LOB form mismatch
  • ora-09886 : osnTXtt: translation error while expanding txipc@.trc.
  • ora-02068 : following severe error from stringstring
  • ora-12647 : Authentication required
  • ora-04008 : START WITH cannot be more than MAXVALUE
  • ora-31460 : logfile location string is not an existing directory
  • ora-16135 : Invalid LOG_ARCHIVE_CONFIG modification while in protected mode
  • ora-28555 : pass-through SQL: required parameter missing or NULL
  • ora-23313 : object group "string"."string" is not mastered at string
  • ora-29534 : referenced object string.string could not be resolved
  • ora-01205 : not a data file - type number in header is string
  • ora-31058 : cannot modify read-only XOBs
  • ora-15028 : ASM file 'string' not dropped; currently being accessed
  • ora-31015 : Attempted to insert entry without name
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-10567 : Redo is inconsistent with data block (file# string, block# string)
  • ora-38469 : invalid privilege for an expression set: string
  • ora-00309 : log belongs to wrong database
  • ora-33214 : (CINSERT02) The workspace object dimension is too large.
  • ora-14108 : illegal partition-extended table name syntax
  • ora-02728 : osnfop: access error on oracle executable
  • 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.