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-07339: spcre: maximum number of semaphore sets exceeded.
ORA-00299: must use file-level media recovery on data file string
ORA-31042: Too many properties in type 'string'
RMAN-06572: database is open and datafile number is not offline
IMG-00717: destination image format does not support process options
ORA-23470: invalid status
RMAN-06708: short write while writing file "string". Wrote string bytes instead of string bytes
ORA-14288: index is not partitioned by Composite Range method
ORA-25452: duplicate attribute value for variable: string, attribute: string
ORA-28113: policy predicate has error
ORA-00116: SERVICE_NAMES name is too long
PLS-00105: at most one forward declaration of type 'string' is permitted