ORA-22331: cannot alter an incomplete type

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

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

Use CREATE TYPE to completely define the original type before executing the ALTER TYPE.

update : 29-05-2017
ORA-22331

ORA-22331 - cannot alter an incomplete type
ORA-22331 - cannot alter an incomplete type

  • ora-01516 : nonexistent log file, datafile, or tempfile "string"
  • ora-25234 : NEXT_TRANSACTION navigation option invalid for queue table string.string
  • ora-23615 : Block number string does not exist for script string
  • ora-09986 : wrong number of bytes read from SGA definition file
  • ora-32338 : on commit refresh grab all the detailed tables
  • ora-19261 : XQ0041 - non empty URI in QName
  • ora-16510 : messaging error using ksrwait
  • ora-23430 : argument "string" cannot be NULL or empty string
  • ora-06517 : PL/SQL: Probe error - string
  • ora-28503 : bind value cannot be translated into SQL text for non-Oracle system
  • ora-02830 : Segment could not be split - no free segments available
  • ora-04060 : insufficient privileges to execute string
  • ora-12626 : TNS:bad event type
  • ora-27509 : IPC error receiving a message
  • ora-23490 : extension request "string" with status "string" not allowed in this operation
  • ora-31416 : invalid SOURCE_COLMAP value
  • ora-10577 : Can not invoke test recovery for managed standby database recovery
  • ora-16178 : Cannot specify remote destinations in archivelog manual mode
  • ora-14627 : Invalid operation was specified on a GLOBAL partitioned index
  • ora-07250 : spcre: semget error, unable to get first semaphore set.
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-06005 : NETASY: dialogue file read failure
  • ora-00155 : cannot perform work outside of global transaction
  • ora-07480 : snchmod: cannot change permissions on ?/dbs/sgalm.dbf.
  • ora-29305 : cannot point-in-time recover tablespace 'string'
  • ora-14165 : MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
  • ora-06911 : CMX: t_event returns ERROR
  • ora-16598 : Data Guard broker detected a mismatch in configuration
  • ora-19805 : recid string of string was deleted to reclaim disk space
  • ora-06124 : NETTCP: timeout waiting for ORASRV
  • 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.