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 : 27-04-2017
ORA-22861

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

  • ora-14553 : cannot perform a lob write operation inside a query
  • ora-33219 : (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-07590 : spdde: $DELPRC failure
  • ora-28345 : cannot downgrade because there exists encrypted column
  • ora-00332 : archived log is too small - may be incompletely archived
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-38728 : Cannot FLASHBACK DATABASE to the future.
  • ora-39305 : schema "string" does not exist
  • ora-06442 : ssvwatev: Failed with unexpected error number.
  • ora-01946 : DEFAULT TABLESPACE already specified
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-31700 : Very long string supplied for AUDIT_SYSLOG_LEVEL parameter
  • ora-19680 : some blocks not recovered. See trace file for details
  • ora-16580 : bad Data Guard NetSlave network link
  • ora-07406 : slbtpd: invalid number.
  • ora-32405 : cannot alter tablespace for existing materialized view log
  • ora-16645 : unexpected new instance interrupted current operation
  • ora-24042 : no propagation schedule exists for QUEUE string and DESTINATION string
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-28512 : cannot get data dictionary translations from string
  • ora-14307 : partition contains too many list values
  • ora-01121 : cannot rename database file string - file is in use or recovery
  • ora-14642 : Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-00088 : command cannot be executed by shared server
  • ora-32807 : message system link string already exists
  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-01508 : cannot create database; error in file 'string' at line string
  • ora-32812 : subscriber string does not exist
  • ora-22981 : must specify a table/view having system generated OID
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • 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.