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 ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...