Oracle Solution for Error ora-25955

ORA-25955: all tables must be joined in the where clause

What triggered the Error:

attempt to create a join index was made, which failed because one of the tables in the from clause did not appear in the where clause.

What should we do to fix it:

sure that the where clause contains all from clause tables.