ORA-22339: cannot alter to not final since its attribute
column is substitutable
- 1 Answers
- 2181 Views
- I also Faced
- E-Mail Answers
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 |
PLS-00142: duplicate external PARAMETER list specification in subprogram expression
ORA-01642: begin backup not needed for read only tablespace 'string'
ORA-12157: TNS:internal network communication error
ORA-00134: invalid DISPATCHERS specification #string
NNL-00017: cannot start server, program "string" does not exist
NID-00330: The following datafiles are offline immediate:
ORA-22316: input type is not a collection type
TNS-12629: TNS:no event test
ORA-14102: only one LOGGING or NOLOGGING clause may be specified
ORA-01891: Datetime/Interval internal error
TNS-00146: Internal-- Retry data request withing pump.
ORA-27042: not enough space on raw partition to fullfill request
Oracle Errors 
