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

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

Question Posted / guest

1 Answers
3167 Views
I also Faced
E-Mail Answers

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

NNL-00233: Auto-refresh failure-retry interval is now string

1 Answers

ORA-26521: rpc initialization error

1 Answers

ORA-25153: Temporary Tablespace is Empty

1 Answers

LSX-00118: fixed facet value cannot be changed

1 Answers

ORA-19960: Internal use only

1 Answers

PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types

1 Answers

NZE-28819: No distinguished name provided.

1 Answers

NID-00371: Change database name of database string to string? (Y/[N]) =>

1 Answers

ORA-24093: AQ agent string not granted privileges of database user string

1 Answers

PLS-00664: Both ORDER BY and CLUSTER BY can not be specified for the same table function

1 Answers

ORA-01939: only the ADMIN OPTION can be specified

1 Answers

ORA-38959: Failed to update block 0 to new version 10 format

1 Answers

For more Oracle Errors Interview Questions Click Here