Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-22339: cannot alter to not final since its attribute
column is substitutable
- 1 Answers
- 2917 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 |
ORA-01263: Name given for file destination directory is invalid
ORA-19643: datafile string: incremental-start SCN is too recent
ORA-01618: redo thread string is not enabled - cannot mount
ORA-16503: site ID allocation failure
ORA-12488: maximum label does not dominate minimum label
DRG-10561: index string is not valid for requested operation
ORA-31011: XML parsing failed
ORA-28292: No Domain Policy registered for Kerberos based authentication
ORA-13764: Value "string" is illegal as a result percentage.
ORA-08191: Flashback Table operation is not supported on remote tables
ORA-19815: WARNING: string of string bytes is string used, and has string remaining bytes available.
ORA-09270: szalloc: error allocating memory for security
Oracle Errors 
