ORA-22346: Type has cyclical dependency. Should use CASCADE
option



ORA-22346: Type has cyclical dependency. Should use CASCADE option..

Answer / guest

Cause: An attempt was made to alter a type which has a
cyclical dependency, with invalidate option.

Action: Give CASCADE option instead of INVALIDATE

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00248: Invalid Library Syntax

1 Answers  


DRG-10595: ALTER INDEX string failed

1 Answers  


ORA-19559: error sending device command: string

1 Answers  


ORA-32741: Hang analysis already going on

1 Answers  


ORA-13602: The specified parameter string is not valid for task or object string.

1 Answers  






ORA-12094: error during online redefinition

1 Answers  


RMAN-08159: executing global script: string

1 Answers  


ORA-39044: Metadata transform string has already been specified.

1 Answers  


SQL*Loader-00626: Character set conversion buffer overflow.

1 Answers  


ORA-27485: argument string already exists at a different position

1 Answers  


ORA-24052: cannot propagate object type payloads with LOB attributes to an 8.0 release

1 Answers  


NNC-00402: program interface de-initialization failed

1 Answers  


Categories