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

NZE-29115: Cannot export private key.

1 Answers  


ORA-09792: sllfop: cannot allocate read buffer.

1 Answers  


TNS-00203: Unable to start tracing in intlsnr

1 Answers  


ORA-19336: Missing XML root element

1 Answers  


ORA-29500: NAMED keyword is invalid in CREATE JAVA CLASS

1 Answers  


ORA-09758: osnipn: could not check port in name server.

1 Answers  


ORA-25016: cannot specify column list for insert into nested table view column

1 Answers  


RMAN-06109: changed archive log unavailable

1 Answers  


ORA-12632: Role fetch failed

1 Answers  


ORA-24202: publisher does not exist for the queue

1 Answers  


ORA-10562: Error occurred while applying redo to data block (file# string, block# string)

1 Answers  


RMAN-06220: Creating automatic instance

1 Answers  


Categories