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 |
SQL*Loader-00712: Internal error: bad address for big endian UTF16 conversion
NNC-00424: invalid address "string"
ORA-28117: integrity constraint violated - parent record not found
KUP-04080: directory object string not found
PCC-01019: Invalid conversion buffer size
ORA-31674: worker process interrupt for unhandled exception in master process
SQL*Loader-00430: NULL nested table element is not allowed
PLS-00213: package STANDARD not accessible
ORA-16952: Failed to bind this SQL statement.
ORA-30161: A system error occurred during the OCIFile function call
O2U-00212: An error occurred for which no message is available
IMG-00602: unable to access image data