ORA-22861: invalid user-defined type

Cause : Ana ttmeptw asm ad etoc retae acoulmno r bojetc tbaleo f ano-n eixstnet ytpe.

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

Spceif ya avli dtyep i nth etalbe ro cloum ndeifniiton.

update : 25-06-2017
ORA-22861

ORA-22861 - invalid user-defined type
ORA-22861 - invalid user-defined type

  • ora-16645 : unexpected new instance interrupted current operation
  • ora-39116 : invalid trigger operation on mutating table string.string
  • ora-22809 : nonexistent attribute
  • ora-16235 : DDL skipped because import has occurred
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-13442 : GeoRaster metadata SRS error
  • ora-06144 : NETTCP: SID (database) is unavailable
  • ora-16246 : User initiated abort apply successfully completed
  • ora-38416 : A stored attribute may not be longer then 300 characters.
  • ora-32830 : result code string returned by Messaging Gateway agent
  • ora-13869 : Instance-wide SQL tracing on instance string is already enabled
  • ora-30964 : The XML Index was not usable.
  • ora-24381 : error(s) in array DML
  • ora-23495 : serial propagation can not be used for "string"
  • ora-01947 : TEMPORARY TABLESPACE already specified
  • ora-22625 : OCIAnyData is not well-formed
  • ora-24354 : number fetched too large to fit in COBOL display type buffer.
  • ora-23421 : job number string is not a job in the job queue
  • ora-19256 : XQ0036 - missing type definitions in imported module
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-01981 : CASCADE CONSTRAINTS must be specified to perform this revoke
  • ora-13514 : Metric Capture too close to last capture, group string
  • ora-19008 : Invalid version of the XMLType
  • ora-13755 : invalid "SQL Tuning Set" name
  • ora-29910 : invalid callback operation
  • ora-33280 : (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
  • ora-30178 : duplicate flag used in a format specification
  • ora-01463 : cannot modify column datatype with current constraint(s)
  • ora-19511 : Error received from media manager layer, error text: string
  • 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.