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-16409: Archive log switchover reference number mismatch

1 Answers  


LFI-00125: Random access only allowed on fixed length record files.

1 Answers  


DGM-16909: Fatal error - quitting...

1 Answers  


ORA-22929: invalid or missing directory name

1 Answers  


LSX-00027: property "~s" unknown

1 Answers  






TNS-01082: Running in PROXY mode

1 Answers  


ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause

1 Answers  


ORA-01183: cannot mount database in SHARED mode

1 Answers  


ORA-25404: lost instance

1 Answers  


EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$

1 Answers  


ORA-27077: too many files open

1 Answers  


ORA-26064: Invalid SCN specified - Wrap: string Base: string.

1 Answers  


Categories