ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option


Cause:


An option other than INITRANS, MAXTRANS,or STORAGE is specified in an ALTER INDEX statement or in the USING INDEX clause of an ALTER MATERIALIZED VIEW statement.



Action:


Specify only legal options.