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-07753: slemcf: fseek before write failure
IMG-00814: fail queue free failed
ORA-24192: the property name cannot be null
ORA-39095: Dump file space has been exhausted: Unable to allocate string bytes
ORA-02302: invalid or missing type name
RMAN-06448: uncataloged proxy copy
RMAN-06093: recovery catalog contains obsolete version of datafile string
ORA-13182: failed to read element string.string.string
ORA-13183: unsupported geometric type for geometry string.string
LSX-00220: "~1S" is wrong length, should be ~2d
NMP-00009: SNMP initialization failure
ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.