ORA-25956: join index cannot be created on tables owned by SYS

You are here: Home // Oracle 11g // ORA-25956: join index cannot be created on tables owned by SYS

Cause: An attempt to create a join index was made, which failed because one of the tables was owned by SYS. See the solution below.

Error solution: Ensure that no join index related table is owned by SYS.

Database version: Oracle 11g Release 2 (11.2)