Database Error Messages

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.