ORA-02242: no options specified for ALTER INDEX



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

Post New Answer

More Oracle Errors Interview Questions

ORA-00382: %s not a valid block size, valid range [string..string]

1 Answers  


ORA-25400: must replay fetch

1 Answers  


ORA-30375: materialized view cannot be considered fresh

1 Answers  


ORA-06140: NETTCP: no such user

1 Answers  


TNS-04074: Invalid value for the parameter string.

1 Answers  






ORA-39706: schema 'string' not found

1 Answers  


ORA-01172: recovery of thread string stuck at block string of file string

1 Answers  


QSM-02101: mv references a synonym in the FROM list

1 Answers  


RMAN-06182: archive log larger than MAXSETSIZE: thread string seq string string

1 Answers  


NZE-28824: invalid encryption/decryption/signature state passed

1 Answers  


ORA-33030: (XSAGDNGL14) In AGGMAP workspace object, you can have either a single independent PROTECT statement or PROTECT statements in your RELATION statements.

1 Answers  


SQL*Loader-00529: OCI return status: invalid handle

1 Answers  


Categories