HomeOracleOracle Error ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD

Oracle Error ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD

Oracle Error Message

ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD

Reason for the Error

The TABLESPACE option to ALTER INDEX was used without the REBUILD option.

Solution

Use ALTER INDEX REBUILD TABLESPACE tablespace name.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...