ORA-22840
REF column column being indexed is not scoped.
- column: The REF column being indexed.
Cause
The REF column being indexed was not a scoped REF column. Only scoped REF columns can be indexed.
Action
If the REF column can be scoped, then do so.