SQL> alter index TEMP_UK2 rebuild BF_TEMP online;
alter index TEMP_UK2 rebuild BF_TEMP online
*
ERROR at line 1:
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
I think we need to recreate the index or probably thinking of reorganize the table in one go....




Reply With Quote