Oracle Solution for Error ora-25960

ORA-25960: join index cannot be based on a temporary table

What triggered the Error:

attempt to create a join index was made, which failed because one of the tables was temporary.

What should we do to fix it:

sure no underlying tables are temporary.