Oracle DBA, How To, Error, Cause and Action

ORA-14038: GLOBAL partitioned index must be prefixed

ORA-14038: GLOBAL partitioned index must be prefixed


Cause:


User attempted to create a GLOBAL non-prefixed partitioned index which is illegal



Action:


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

No comments:

Post a Comment

Thanks for your comment.