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-24061: cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_INSTANCE was zero
NZE-28822: Required seed is not specified.
ORA-29883: cannot create a domain index on column expressions
SQL*Loader-00500: Unable to open file (string)
ORA-23291: Only base table columns may be renamed
ORA-12163: TNS:connect descriptor is too long
ORA-01662: tablespace 'string' is non-empty and cannot be made temporary
ORA-26054: Direct Path Context prepared for a different mode than operation requested.
ORA-06816: TLI Driver: could not set the SPX SAP address
ORA-06267: NETNTT: bad state
ORA-19851: OS error while managing auxiliary database string
ORA-16587: Ambiguous object specified to Data Guard broker