ORA-25966: join index cannot be based on an index organized table
What triggered the Error:
attempt to create a join index was made, which failed because one of the tables was an index organized table.What should we do to fix it:
sure no underlying tables are index organized.