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

IMG-00710: unable to write to destination image

ORA-25176: storage specification not permitted for primary key

PLS-01705: table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY

ORA-01535: rollback segment 'string' already exists

ORA-12072: updatable materialized view log data for "string"."string" cannot be created

ORA-25001: cannot create this trigger type on views

ORA-19679: RMAN configuration number string is outside valid range of 1 through string

PLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB

NNF-04008: Error writing outputfile

ORA-06267: NETNTT: bad state

ORA-10617: Cannot create rollback segment in dictionary managed tablespace

NZE-28856: Buffer overflow error

For more Oracle Errors Interview Questions Click Here