ORA-24183: invalid transformation

Cause : The trnasformaiton speicfied i sinvali dbecaus ethe soruce or hte targte type ahve bee ndroppe/dmodifide.

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

Drop adn recretae the rtansforamtion

update : 28-04-2017
ORA-24183

ORA-24183 - invalid transformation
ORA-24183 - invalid transformation

  • ora-02717 : osnpfs: incorrect number of bytes written
  • ora-13831 : SQL profile name specified is invalid
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • ora-29831 : operator binding not found
  • ora-06567 : invalid number of values specified
  • ora-24788 : cannot switch to specified transaction (server type)
  • ora-24392 : no connection pool to associate server handle
  • ora-07478 : scgcmn: cannot get lock status.
  • ora-19264 : XQ0044 - invalid namespace in attribute constructors
  • ora-06025 : NETASY: Configuration error
  • ora-30338 : illegal dimension hierachy name
  • ora-36220 : (XSLPDSC01) All dimensions in LIST number are also in the IGNORE clause.
  • ora-28525 : unable to create Heterogeneous Services error message text
  • ora-39147 : cannot migrate Data Pump queue table ownership to this instance
  • ora-37023 : (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.
  • ora-02494 : invalid or missing maximum file size in MAXSIZE clause
  • ora-16002 : database already open for read-write access by another instance
  • ora-01279 : db_files too large
  • ora-39220 : file name is too long
  • ora-30373 : object data types are not supported in this context
  • ora-31625 : Schema string is needed to import this object, but is unaccessible
  • ora-12810 : PARALLEL_MAX_SERVERS must be less than or equal to string
  • ora-39317 : call to DBMS_SCHEMA_COPY.VALIDATION_CHECK is not legal
  • ora-10281 : maximum time to wait for process creation
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • ora-12582 : TNS:invalid operation
  • ora-12025 : materialized view log on "string"."string" already has primary keys
  • ora-06603 : LU6.2 Driver: Error allocating memory
  • ora-13840 : Concurrent DDL Error in create SQL profile operation.
  • ora-14020 : this physical attribute may not be specified for a table partition
  • 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.