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-09-2017

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-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-38410 : schema extension not allowed for the table name
  • ora-12488 : maximum label does not dominate minimum label
  • ora-07717 : sksaalo: error allocating memory
  • ora-02249 : missing or invalid value for MAXLOGMEMBERS
  • ora-29918 : cannot create domain indexes on temporary tables
  • ora-25190 : an index-organized table maintenance operation may not be combined with other operations
  • ora-25280 : complete sender information not provided to non-repudiate sender
  • ora-28578 : protocol error during callback from an external procedure
  • ora-38757 : Database must be mounted and not open to FLASHBACK.
  • ora-37172 : illegal dimension type
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-09829 : pw_createPorts: server call pws_start_instance failed.
  • ora-38783 : Instance recovery required.
  • ora-26050 : Direct path load of domain index is not supported for this column type.
  • ora-27022 : skgfqsbi: could not allocate memory for media manager
  • ora-19509 : failed to delete sequential file, handle="string", parms="string"
  • ora-19762 : invalid file type string
  • ora-13043 : failed to read metadata from the _SDOLAYER table
  • ora-02738 : osnpwrtbrkmsg: incorrect number of bytes written
  • ora-01573 : shutting down instance, no further change allowed
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-16051 : parameter string contains an invalid delay time
  • ora-32609 : missing REFERENCE keyword in MODEL clause
  • ora-13272 : geometric object string in table string is invalid
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-03221 : Temporary tablespaces and temporary segments must have standard block size
  • ora-29377 : consumer group string is not part of top-plan string
  • ora-38730 : Invalid SCN/TIMESTAMP expression.
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf 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.