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

ORA-08452: specification of E in picture mask is unsupported

1 Answers  


EXP-00047: Missing tablespace name(s)

1 Answers  


O2U-00208: One or more characters in an attribute name were not legal identifier characters

1 Answers  


NZE-28862: SSL connection failed

1 Answers  


TNS-00009: INTCTL: could not contact destination Connection Manager

1 Answers  






RMAN-06545: "string" is an invalid response - please re-enter.

1 Answers  


TNS-00139: Internal - Data passed from the Interchange listener is poorly formed

1 Answers  


ORA-07605: szprv: $ASCTOID failure

1 Answers  


ORA-01779: cannot modify a column which maps to a non key-preserved table

1 Answers  


PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands

1 Answers  


ORA-32400: cannot use object id columns from materialized view log on "string"."string"

1 Answers  


TNS-12509: TNS:listener failed to redirect client to service handler

1 Answers  


Categories