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-04-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-10927 : trace name context forever
  • ora-14400 : inserted partition key does not map to any partition
  • ora-12602 : TNS: Connection Pooling limit reached
  • ora-40106 : positive target value not specified for computing Lift
  • ora-12467 : minimum label can contain a level only
  • ora-30049 : Internal event for TA enq tracing
  • ora-38760 : This database instance failed to turn on flashback database
  • ora-00408 : parameter string is set to TRUE
  • ora-13200 : internal error [string] in spatial indexing.
  • ora-00264 : no recovery required
  • ora-30336 : no child for specified JOIN KEY
  • ora-39017 : Worker request not supported when job is in string state.
  • ora-38709 : Recovery Area is not enabled.
  • ora-25154 : column part of USING clause cannot have qualifier
  • ora-13216 : failed to update spatial index
  • ora-22345 : recompile type string.string before attempting this operation
  • ora-06123 : NETTCP: cannot set KEEPALIVE
  • ora-02330 : datatype specification not allowed
  • ora-12851 : PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
  • ora-31401 : change source string is not an existing change source
  • ora-01509 : specified name 'string' does not match actual 'string'
  • ora-16536 : unknown object type
  • ora-23362 : invalid user
  • ora-30945 : Could not create mapping table 'string'
  • ora-33058 : (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.
  • ora-08260 : ora_addr: cannot open nameserver
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-06019 : NETASY: invalid login (connect) string
  • ora-28343 : fails to encrypt data
  • ora-36873 : (XSTFDSC03) Column type must be specified explicitly.
  • 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.