ORA-22339: cannot alter to not final since its attribute
column is substitutable
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-50868: failed to free statement handle
NNC-00420: operation not allowed
LCD-00212: runaway quoted string [string]
ORA-00316: log string of thread string, type string in header is not log file
ORA-00827: could not shrink sga_target to specified value
ORA-23490: extension request "string" with status "string" not allowed in this operation
ORA-30432: summary 'string.string' is in INVALID state
ORA-02832: Segment deallocation failed - segment not on list
PLS-00599: SAMPLE percentage must be in the range [0.000001,100)
NNO-00262: warning: cannot write checkpoint file "string"
ORA-25223: user_data type used is not supported
ORA-08233: smsdes: cannot unmap SGA