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

PCC-02451: Value of offset cannot be negative in ABSOLUTE orientation mode

DRG-11720: too many synonyms per synonym ring

ORA-01951: ROLE 'string' not granted to 'string'

PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

DRG-11845: No Partial Update

ORA-22851: invalid CHUNK LOB storage option value

ORA-19573: cannot obtain string enqueue for datafile string

ORA-07842: sllfcl: SYS$CLOSE failure

ORA-31155: attribute string not in XDB namespace

ORA-06810: TLI Driver: could not set the IPX ethernet SAP at init

ORA-13637: Executing or modifying task string is disallowed until the task is reset to its initial state.

RMAN-06116: cannot crosscheck unavailable object

For more Oracle Errors Interview Questions Click Here