ORA-22339: cannot alter to not final since its attribute
column is substitutable



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

Post New Answer

More Oracle Errors Interview Questions

ORA-13189: recursive SQL parse failed

1 Answers  


PCC-01016: "N" character literals not supported in embedded PL/SQL

1 Answers  


ORA-23383: registration for materialized view repgroup "string"."string" failed at site string

1 Answers  


ORA-09930: LUB of two labels is invalid

1 Answers  


ORA-16198: Timeout incurred on internal channel during remote archival

1 Answers  






ORA-01309: invalid session

1 Answers  


ORA-16733: Error executing dbms_logstdby.unskip procedure

1 Answers  


PLS-00134: Pragma string expects 2nd argument to be an identifier or string-literal

1 Answers  


SQL*Loader-00532: OCI return status: continue

1 Answers  


ORA-14306: List value 'string' specified twice in partitions 'string', 'string'

1 Answers  


ORA-29301: wrong DBMS_PITR package function/procedure order

1 Answers  


NCR-01010: NCRS: Invalid network address length.

1 Answers  


Categories