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

AMD-00103: %s "string" does not have a string

1 Answers  


ORA-24815: Invalid character set form

1 Answers  


ORA-36202: (XSAGOP01) 'number' is not a valid aggregation operator.

1 Answers  


ORA-06438: ssaio: the asynchronous read was unable to read from the database file.

1 Answers  


LFI-00132: Record length string is greater than max length of string.

1 Answers  






ORA-02337: not an object type column

1 Answers  


ORA-14028: missing AT or VALUES keyword

1 Answers  


ORA-26679: operation not allowed on LOB or LONG columns in LCR

1 Answers  


TNS-00046: INTCTL: Could not contact the CMANAGER on address

1 Answers  


ORA-25234: NEXT_TRANSACTION navigation option invalid for queue table string.string

1 Answers  


ORA-38723: Invalid SCN expression.

1 Answers  


PLS-00514: INSERT statement with REF INTO clause requires a typed table

1 Answers  


Categories