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-04050: invalid or missing procedure, function, or package name
ORA-02710: osnpop: fork failed
ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE
TNS-12510: TNS:database temporarily lacks resources to handle the request
ORA-24021: queue table definition not imported for string.string
ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
ORA-16195: DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined
LSX-00201: contents of "~S" should be elements only
IMG-00921: threshold out of range
ORA-13356: adjacent points in a geometry are redundant
IMP-00013: only a DBA can import a file exported by another DBA
ORA-12404: invalid privilege string: string