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

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

Question Posted / guest

1 Answers
3077 Views
I also Faced
E-Mail Answers

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

Answer / guest

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

Action: Use ALTER INDEX REBUILD TABLESPACE tablespace name.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-26094: stream format error: input column overflow

0 Answers HP,

LFI-01514: ftell() failed in string

1 Answers

ORA-30024: Invalid specification for CREATE UNDO TABLESPACE

1 Answers

RMAN-03036: Debugging set to level=number, types=string

1 Answers

SQL-02130: EXEC TOOLS interface is not available.

1 Answers

ORA-27009: skgfwrt: cannot write to file opened for read

1 Answers

ORA-01196: file string is inconsistent due to a failed media recovery session

1 Answers

SQL*Loader-00958: Error popping data relocation address stack

1 Answers

ORA-02188: Cannot enable instance publicly

1 Answers

ORA-19553: device name string is invalid

1 Answers

ORA-30937: No schema definition for 'string' (namespace 'string') in parent 'string'

1 Answers

ORA-07680: sou2os: another call to ORACLE currently executing

1 Answers

For more Oracle Errors Interview Questions Click Here