Oracle DBA, How To, Error, Cause and Action

ORA-14143: CREATE INDEX INVISIBLE may not be used with this type of index

ORA-14143: CREATE INDEX INVISIBLE may not be used with this type of index


Cause:


Certain types of indexes (IOT-TOP, Cluster indexes) cannot be created invisible.



Action:


Remove the option INVISIBLE

No comments:

Post a Comment

Thanks for your comment.