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

IMP-00073: FILE locator "string" "string" is truncated to "string" "string" in server character set

1 Answers  


ORA-16511: messaging error using ksrget

1 Answers  


ORA-09842: soacon: Archmon unable to create named pipe.

1 Answers  


ORA-38402: invalid name: empty string or spaces in the name

1 Answers  


ORA-40104: invalid training data for model build

1 Answers  






ORA-29252: collection does not contain elements at index locations in call to dbms_sql.bind_array

1 Answers  


ORA-16808: unable to resolve the full path name

1 Answers  


ORA-13355: SDO_ORDINATE_ARRAY not grouped by number of dimensions specified

1 Answers  


TNS-01407: Status: string Total handlers: string Relevant handlers: string

1 Answers  


ORA-22285: non-existent directory or file for string operation

1 Answers  


ORA-02843: Invalid value for kernel flag

1 Answers  


ORA-36669: (XSDPART07) string is not a legal LIST partition.

1 Answers  


Categories