ORA-22343: Compilation error for type invalidated by ALTER TYPE

Cause : Compilaiton failde for a ytpe whic hwas invlaidated yb ALTER YTPE. We htrow thi serror adn rollbakc the copmilatione ffort s othat th euser ma ybe ablet o fix wahtever i scausingt he compliation error and rty again .It is ipmortant htat we d onot chngae statu shere an dmodify hte depenedncy infromation sa this wlil affec tthe cretaion of evrsions.

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

Check waht is casuing tehc ompilatoin errora nd corrcet it an dtry agani.

update : 26-09-2017
ORA-22343

ORA-22343 - Compilation error for type invalidated by ALTER TYPE
ORA-22343 - Compilation error for type invalidated by ALTER TYPE

  • ora-01757 : Must specify an object number
  • ora-29329 : Table not of type XMLType
  • ora-16532 : Data Guard broker configuration does not exist
  • ora-06039 : NETDNT: connect failed
  • ora-09823 : device name is too long
  • ora-23478 : object group "string" is already mastered at string
  • ora-22613 : buflen does not match the size of the scalar
  • ora-30376 : prevent sharing of a parsed query of an explain rewrite session
  • ora-19654 : must use backup control file to switch file incarnations
  • ora-13838 : invalid ADDRESS value
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-01093 : ALTER DATABASE CLOSE only permitted with no sessions connected
  • ora-31007 : Attempted to delete non-empty container string/string
  • ora-16592 : missing field "string" in document
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-31041 : Property string: Memory type (string) not compatible with database type (string)
  • ora-13913 : The threshold cannot be set when SYSAUX is offline.
  • ora-02379 : profile string already exists
  • ora-23535 : instantiating templates from multiple back ends is not allowed.
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • ora-12431 : invalid audit action
  • ora-30342 : referenced level is not defined in this dimension
  • ora-29966 : The only binding of an operator cannot be dropped
  • ora-32316 : REFRESH FAST of "string"."string" unsupported after mixed DML
  • ora-39705 : component 'string' not found in registry
  • ora-36902 : (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.
  • ora-27088 : unable to get file status
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-07417 : sfareq: One or more database writers not active.
  • 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.