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 |
ORA-17500: ODM err:string
KUP-11001: files not from the same unload operation
RMAN-08005: new incarnation of database registered in recovery catalog
ORA-14038: GLOBAL partitioned index must be prefixed
NZE-29026: Decryption failure
NNL-00810: Queries received with no type: number
RMAN-08505: output filename=string
ORA-24313: user already authenticated
ORA-25135: cannot use the SINGLE TABLE option
ORA-32400: cannot use object id columns from materialized view log on "string"."string"
PCC-00141: Thread Safety is not implemented in this precompiler
ORA-31431: all source tables must belong to the synchronous change set