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 |
PCC-02450: Cursor was not declared in scrollable mode
ORA-13524: error encountered while retrieving baseline information
ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater
ORA-01272: REUSE only allowed when a file name is provided.
ORA-25203: invalid value string, DELAY should be non-negative
ORA-25149: Columns of UROWID type may not be indexed
DRG-11130: no data found in the collection
ORA-29285: file write error
ORA-32127: REFs do not belong to any connection
ORA-13044: the specified tile size is smaller than the tolerance
ORA-26685: cannot apply transactions from multiple sources
LSX-00215: value "~1S" whose total digits exceeds ~2d