Expand To Show Full Article
Oracle Error ORA-25953: join index cannot be a functional index - Developer Publish

Oracle Error ORA-25953: join index cannot be a functional index

Oracle Error Message

ORA-25953: join index cannot be a functional index

Reason for the Error

An attempt to create a join index was made, which failed because a functional index was requested or necessary (such as is the case for indexing columns using timezone).

Solution

Remove any functional indexing columns.