ORA-22338: must specify CASCADE INCLUDING DATA when altering
the final property



ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property..

Answer / guest

Cause: An attempt was made to alter the final property of a
type with dependent table(s) without specifying the CASCADE
INCLUDING DATA . option.

Action: Resubmit the statement with the CASCADE INCLUDING
DATA option.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29528: invalid Java call in trigger string

1 Answers  


DRG-12412: missing or invalid Template Processor attribute (string)

1 Answers  


PROT-00001: Failed to initialize ocrconfig

2 Answers  


ORA-02354: error in exporting/importing data string

1 Answers  


SQL*Loader-00272: Table level OPTIONS statement ignored.

1 Answers  






ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

1 Answers  


PLS-00637: FINAL method cannot be overriden or hidden

1 Answers  


ORA-00234: error in identifying or opening snapshot or copy controlfile

1 Answers  


ORA-32614: illegal MODEL SELECT expression

1 Answers  


PLS-00407: '*' not allowed here; a list of columns is required

1 Answers  


ORA-30680: debugger connection handshake failed

1 Answers  


ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents

1 Answers  


Categories