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

ORA-02302: invalid or missing type name

1 Answers  


PROC-00024: Error in the messaging layer

1 Answers  


IMP-00019: row rejected due to ORACLE error number

1 Answers  


RMAN-08151: replaced global script string

1 Answers  


ORA-31613: Master process string failed during startup.

1 Answers  






LPX-00660: Not a well-formed document or external entity.

1 Answers  


NNL-01040: Data streams opened by server: number

1 Answers  


DRG-11862: This Is Probaly A HTTP Server 0.9 Or Less

1 Answers  


PLS-00232: nested packages not permitted

2 Answers  


ORA-39025: jobs of type string are not restartable

1 Answers  


ORA-00099: timed out while waiting for resource, potential PDML deadlock

1 Answers  


ORA-00085: current call does not exist

1 Answers  


Categories