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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Oracle Errors Interview Questions

KUP-03016: length specified for FIXED records must be greater than 0

1 Answers  


ORA-06578: output parameter cannot be a duplicate bind

1 Answers  


ORA-24416: Invalid session Poolname was specified.

1 Answers  


DRG-52100: %(1)s returned internal error code string

1 Answers  


ORA-23335: priority group string already exists

1 Answers  


ORA-24162: name value pair list is full, cannot add another entry

1 Answers  


TNS-00028: INTCTL: Could not resolve Connection Manager's name/address

1 Answers  


ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement

1 Answers  


ORA-02087: object locked by another process in same transaction

1 Answers  


ORA-31116: Tablespace not specified correctly

1 Answers  


PLS-00737: LIBRARY file specification exceeds the maximum allowed length

1 Answers  


AMD-00134: measure #string: RDBMS measure column name not specified

1 Answers  


Categories