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-07753: slemcf: fseek before write failure

1 Answers  


IMG-00814: fail queue free failed

1 Answers  


ORA-24192: the property name cannot be null

1 Answers  


ORA-39095: Dump file space has been exhausted: Unable to allocate string bytes

1 Answers  


ORA-02302: invalid or missing type name

1 Answers  


RMAN-06448: uncataloged proxy copy

1 Answers  


RMAN-06093: recovery catalog contains obsolete version of datafile string

1 Answers  


ORA-13182: failed to read element string.string.string

1 Answers  


ORA-13183: unsupported geometric type for geometry string.string

1 Answers  


LSX-00220: "~1S" is wrong length, should be ~2d

1 Answers  


NMP-00009: SNMP initialization failure

1 Answers  


ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.

1 Answers  


Categories