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-33280: (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.

1 Answers  


ORA-19627: cannot read backup pieces during controlfile application

1 Answers  


DRG-10822: duplicate query name

1 Answers  


ORA-07631: smcacx: $EXPREG failure

1 Answers  


DRG-10579: must provide text query criteria

1 Answers  


ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.

1 Answers  


ORA-13797: invalid SQL Id specified, string

1 Answers  


ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

1 Answers  


ORA-13481: the destination type is not supported

1 Answers  


ORA-06142: NETTCP: error getting user information

1 Answers  


PLS-00219: label 'string' reference is out of scope

1 Answers  


PCB-00230: Indicator table size must not be less than its host variable

1 Answers  


Categories