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

Oracle 316 Views 0 Min Read

Oracle Error Message

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

Reason for the Error

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.

Solution

Specify only legal options.

Tags: