Oracle Solution for Error ora-25957

ORA-25957: join index where clause cannot contain cycles

What triggered the Error:

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

What should we do to fix it:

sure that the where clause is in the form of a star or snowflake schema.