ORA-22339: cannot alter to not final since its attribute column is substitutable

Cause : Ana ttmeptw asm ad etoa ltre at yp eton otf inla wehn tis mebeddeda ttirbuet i sdeifne dass ubtsittuabel i nsoem tbale.s Ntoe,t hi sisa rsetrcitino i n9. 0vesrio nbeacus ewhne at yp eisa ltreedt o ont ifna,l cloum noft ha ttyep i sse tton ots ubtsittuabel a tal lleevls ;thsu, ti i sane rrro i fon eofi tse mbdede datrtibtue oclunm i salerad ymakreds ubtsittuabel.

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

Rerceaet teh tbalea nds peicfyN OTS UBTSITTUABEL A TAL LLEEVLSf ora llc olmunso f onn ifna ltyep. hTenr esbumi tth eALETR YTPEs taetmetn.

update : 26-04-2017
ORA-22339

ORA-22339 - cannot alter to not final since its attribute column is substitutable
ORA-22339 - cannot alter to not final since its attribute column is substitutable

  • ora-29253 : Invalid count argument passed to procedure dbms_sql.define_array
  • ora-00701 : object necessary for warmstarting database cannot be altered
  • ora-22298 : length of directory alias name or file name too long
  • ora-14057 : partition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-16595 : NetSlave process string failed to terminate
  • ora-38444 : statistics do not exist for the expression set
  • ora-13226 : interface not supported without a spatial index
  • ora-29365 : parameters string and string cannot both be set
  • ora-00409 : COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
  • ora-02426 : privilege grant failed
  • ora-00151 : invalid transaction ID
  • ora-15090 : handle string is not a valid descriptor
  • ora-12926 : FORCE LOGGING option already specified
  • ora-22603 : cannot add an attribute to the already generated TDS handle
  • ora-12598 : TNS:banner registration failed
  • ora-24787 : remote cursors must be closed before a call completes
  • ora-32840 : property name cannot be NULL
  • ora-08234 : smsget: cannot get instance listener address
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-28278 : No domain policy registered for password based GLOBAL users.
  • ora-27140 : attach to post/wait facility failed
  • ora-09813 : Unable to get directory status
  • ora-29872 : parameters clause cannot be combined with the specified options
  • ora-06532 : Subscript outside of limit
  • ora-37113 : OLAP API initialization error: (string)
  • ora-12729 : invalid character class in regular expression
  • ora-07454 : queue timeout, string second(s), exceeded
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-25120 : MINIMUM EXTENT option already specified
  • ora-12219 : TNS:missing community name from address in ADDRESS_LIST
  • 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.