ORA-22330: cannot alter a type that is not valid

Cause : An attempt was made to perform ALTER TYPE on an invalid type.

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

Use the CREATE OR REPLACE TYPE command to modify the type.

update : 30-04-2017
ORA-22330

ORA-22330 - cannot alter a type that is not valid
ORA-22330 - cannot alter a type that is not valid

  • ora-30358 : summary and materialized view are not in same schema
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-39708 : component 'string' not a string component
  • ora-24230 : input to DBMS_DDL.WRAP is not a legal PL/SQL unit
  • ora-15045 : ASM file name 'string' is not in reference form
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-04079 : invalid trigger specification
  • ora-30205 : invalid Character set
  • ora-40201 : invalid input parameter string
  • ora-02727 : osnpop: access error on orapop executable
  • ora-09853 : snyRemovePort: bad return code from request.
  • ora-38478 : creation of system trigger EXPFIL_DROPOBJ_MAINT failed
  • ora-36650 : (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
  • ora-01699 : tablespace 'string' is being imported for point in time recovery
  • ora-12996 : cannot drop system-generated virtual column
  • ora-07339 : spcre: maximum number of semaphore sets exceeded.
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-08433 : invalid picture type in convert raw to number
  • ora-27001 : unsupported device type
  • ora-31069 : Cannot apply typed changes to non-schema-based XMLType nodes
  • ora-01374 : _log_parallelism_max greater than 1 not supported in this release
  • ora-29264 : unknown or unsupported URL scheme
  • ora-16784 : the database name in Dependency property is incorrect
  • ora-01517 : log member: 'string'
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-38463 : invalid XML Tag list
  • ora-04043 : object string does not exist
  • ora-32010 : cannot find entry to delete in SPFILE
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-31609 : error loading file "string" from file system directory "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.