Showing posts with label ORA-25957: join index where clause cannot contain cycles. Show all posts
Showing posts with label ORA-25957: join index where clause cannot contain cycles. Show all posts

Sunday, 29 April 2012

ORA-25957: join index where clause cannot contain cycles

ORA-25957: join index where clause cannot contain cycles

Cause: An attempt to create a join index was made, which failed because the where clause contains a cycle.

Action: Ensure that the where clause is in the form of a star or snowflake schema.