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-00428: count for field string not stored in character or integer field
ORA-01019: unable to allocate memory in the user side
NPL-00305: unsupported ASN.1 "UNIV" type string
ORA-37028: (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.
QSM-01027: materialized view, string, is unusable
PLS-00562: a function must return a type.
ORA-36666: (XSDPART04) workspace object is not a concat dimension.
ORA-24054: cannot propagate to an Oracle 8.0.3 release or lower release
ORA-15185: Could not close dynamic library string, error [string]
QSM-01033: query rewritten with materialized view, string
ORA-26012: No data found while executing sql statement string for column string - check input for: string
ORA-36978: (XSRELGID01) workspace object must be a self-relation.