Oracle Error Message
ORA-25955: all tables must be joined in the where clause
Reason for the Error
An 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.
Solution
Ensure that the where clause contains all from clause tables.