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-14132: table cannot be used in EXCHANGE
SQL*Loader-00620: Initial enclosure character not found
ORA-28656: incomplete attribute specification
ORA-06321: IPA: Cannot reach the remote side
RMAN-03038: Spooling started in trace file: string
RMAN-06422: no channels found for SEND command
ORA-28300: No permission to read user entry in LDAP directory service.
NID-00371: Change database name of database string to string? (Y/[N]) =>
ORA-12409: policy startup failure for string policy
ORA-01194: file string needs more recovery to be consistent
ORA-06753: TLI Driver: name-to-address mapping failed
LPX-00307: namespace prefix ~S used but not declared