Oracle DBA, How To, Error, Cause and Action

ORA-14227: INDEXING may be specified only when the underlying table is partitioned

ORA-14227: INDEXING may be specified only when the underlying table is partitioned


Cause:


INDEXING FULL or INDEXING PARTIAL was specified during CREATE INDEX or ALTER INDEX when the base table was not partitioned.



Action:


Remove the INDEXING clause from the statement.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)