ORA-22326: cannot change a type to FINAL if it has subtypes



ORA-22326: cannot change a type to FINAL if it has subtypes..

Answer / guest

Cause: An attempt was made to change a type with subtypes to
FINAL.

Action: Drop all subtypes of the target type before changing
it to FINAL.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30944: Error during rollback for XML schema 'string' table string column 'string'

1 Answers  


ORA-12084: must use ALTER MATERIALIZED VIEW to alter "string"."string"

1 Answers  


PLS-00108: declarative units must be a single variable declaration

1 Answers  


ORA-26685: cannot apply transactions from multiple sources

1 Answers  


ORA-00040: active time limit exceeded - call aborted

1 Answers  






DRG-10502: index string does not exist

1 Answers  


QSM-01091: cost based optimizer found query rewrite is more expensive

1 Answers  


RMAN-06183: datafile or datafilecopy larger than MAXSETSIZE: file# string string

1 Answers  


ORA-00702: bootstrap verison 'string' inconsistent with version 'string'

1 Answers  


ORA-14168: only one subpartition may be modified

1 Answers  


ORA-19695: fixed table x$krbmsft has not been populated

1 Answers  


ORA-01591: lock held by in-doubt distributed transaction string

1 Answers  


Categories