ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

Cause : An attempt was made to specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change.

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

Specify CONVERT TO SUBSTITUTABLE option only for ALTER TYPE NOT FINAL change.

update : 23-08-2017
ORA-22344

ORA-22344 - can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
ORA-22344 - can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

  • ora-30557 : function based index could not be properly maintained
  • ora-32121 : Source FILE is null
  • ora-07568 : slspool: $OPEN failure
  • ora-13120 : invalid face_id [string]
  • ora-08113 : composite partition index may not be compressed
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-34177 : (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.
  • ora-26014 : unexpected error on string string while retrieving string string
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-29298 : Character set mismatch
  • ora-35587 : (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number levels.
  • ora-12412 : policy package string is not installed
  • ora-07445 : exception encountered: core dump [string] [string] [string] [string] [string] [string]
  • ora-09944 : Password entry is corrupt.
  • ora-32154 : Anydata context not specified
  • ora-02036 : too many variables to describe with automatic cursor open
  • ora-01370 : Specified restart SCN is too old
  • ora-30746 : error occured while trying to drop column "string" in table "string"
  • ora-29299 : Invalid handle for piecewise compress or uncompress
  • ora-26019 : Column string in table string of type string not supported by direct path
  • ora-00075 : process "string" not found in this instance
  • ora-27474 : cannot give both an argument name and an argument position
  • ora-24902 : invalid subscription name or name-length in subscription handle
  • ora-37175 : column string is not a column of source data
  • ora-38460 : filtering based on datatype "string" not supported for XML Tags
  • ora-02700 : osnoraenv: error translating ORACLE_SID
  • ora-39315 : call to DBMS_SCHEMA_COPY.SWAP is not legal
  • ora-06521 : PL/SQL: Error mapping function
  • ora-19017 : Attributes can only be simple scalars
  • ora-12077 : temporary updatable materialized view log does not exist
  • 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.