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-06302: IPA: Cannot connect to remote host

ORA-19009: Missing XMLSchema keyword

ORA-22880: invalid REF

ORA-07590: spdde: $DELPRC failure

TNS-12663: Services required by client not available on the server

RMAN-08035: partial resync skipped, target database not mounted

TNS-04088: Unable to close atleast one of the connections.

RMAN-06023: no backup or copy of datafile number found to restore

ORA-32306: updatable materialized views with user-defined types must use SELECT *

ORA-12821: invalid value for INSTANCES

ORA-16635: NetSlave connection was broken in the middle of a transmission session.

RMAN-20002: target database already registered in recovery catalog

For more Oracle Errors Interview Questions Click Here