Oracle Solution for Error ora-25100

Solution for Oracle Error ORA-25100

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

What triggered the Error:

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

What should we do to fix it:

e ALTER INDEX REBUILD TABLESPACE tablespace name.