ORA-02242: no options specified for ALTER INDEX

Question Posted / guest

ORA-02242: no options specified for ALTER INDEX..

Answer / guest

Cause: No options specified.

Action: Specify at least one of REBUILD, INITRANS, MAXTRANS,
or STORAGE.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

1 No

More Oracle Errors Interview Questions

ORA-16799: Physical apply service is offline

ORA-13202: failed to create or insert into the SDO_INDEX_METADATA table

ORA-00483: During shutdown a process abnormally terminated

ORA-29864: analyzing domain indexes marked LOADING/FAILED not supported

ORA-24322: unable to delete an initialized mutex

ORA-33054: (XSAGDNGL26) In AGGMAP workspace object, a MIN argument of number must be less than a FLOOR argument of number.

PLS-00145: duplicate external WITH CONTEXT specification in subprogram expression

PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

SQL*Loader-00468: OID directive expects 1 argument, number found.

ORA-16814: incorrect log transport setting for standby's AlternateLocation

ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE

ORA-25195: invalid option for index on an index-organized table

For more Oracle Errors Interview Questions Click Here