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 : 28-05-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-24231 : database access descriptor (DAD) string not found
  • ora-22869 : depth of type dependency hierarchy exceeds maximum limit
  • ora-01599 : failed to acquire rollback segment (string), cache space is full
  • ora-02261 : such unique or primary key already exists in the table
  • ora-30462 : unsupported operator: string
  • ora-24450 : Cannot pre-process OCI statement
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-00255 : error archiving log string of thread string, sequence # string
  • ora-32821 : subscriber queue and exception queue must have same payload type
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-16604 : unable to describe template using package "string"
  • ora-30175 : invalid type given for an argument
  • ora-00403 : %s (string) is not the same as other instances (string)
  • ora-14169 : invalid ALTER TABLE MODIFY SUBPARTITION option
  • ora-07240 : slemrd: seek error.
  • ora-19031 : XML element or attribute string does not match any in type string.string
  • ora-19661 : datafile string could not be verified
  • ora-26060 : Can not convert type identifier for column string
  • ora-30081 : invalid data type for datetime/interval arithmetic
  • ora-12730 : invalid equivalence class in regular expression
  • ora-00102 : network protocol string cannot be used by dispatchers
  • ora-24159 : invalid variable definiton
  • ora-12555 : TNS:permission denied
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-02294 : cannot enable (string.string) - constraint changed during validation
  • ora-01656 : max # extents (string) reached in cluster string.string
  • ora-31673 : worker process interrupt for normal exit by master process
  • ora-29546 : badly formed resource: string
  • ora-26721 : enqueue of the LCR not allowed
  • 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.