Oracle Error ORA-38455: Expression Filter index should be created by the owner.

Oracle Error Message

ORA-38455: Expression Filter index should be created by the owner.

Reason for the Error

An attempt was made to create the Expression Filter index by a user who is not the owner of the index.

Solution

Create the index using owner’s privileges.