ORA-22339: cannot alter to not final since its attribute
column is substitutable
- 1 Answers
- 2199 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: An attempt was made to alter a type to not final when
its embedded attribute is defined as substitutable in some
tables. Note, this is a restriction in 9.0 version because
when a type is altered to not final, column of that type is
set to not substitutable at all levels; thus, it is an error
if one of its embedded attribute column is already marked
substitutable.
Action: Recreate the table and specify NOT SUBSTITUTABLE AT
ALL LEVELS for all columns of non final type. Then resubmit
the ALTER TYPE statement.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
DRG-11124: invalid value string
ORA-06749: TLI Driver: option not allowed across network
ORA-30362: dimension column cannot be a sequence
IMG-00845: internal image index allocation failed
QSM-01037: Query Rewrite failed to allocate the necessary query join graph
NNL-00806: Queries received, type RELATED-INFO: number
ORA-24081: compatible parameter needs to be string or greater
TNS-00200: Unable to do nsanswer on context result=string
ORA-16775: Target standby in switchover operation has missing redo logs.
ORA-19596: SPFILE already included
RMAN-03001: recovery manager command sequencer component initialization failed
LCD-00210: illegal assignment operator [string]
Oracle Errors 
