ORA-14038: GLOBAL partitioned index must be prefixed
What triggered the Error:
User attempted to create a GLOBAL non-prefixed partitioned index which is illegalWhat should we do to fix it:
If the user, indeed, desired to create a non-prefixed index, it must be created as LOCAL; otherwise, correct the list of key and/or partitioning columns to ensure that the index is prefixed