ALTER TABLE REBUILD UNUSABLE INDEX

ALTER TABLE REBUILD UNUSABLE INDEX

To use this statement, is it only against one table or against all tables in the particular schema?

Thanks,
Nirasha

One table

I tried this and it did not work.

I tried first ALTER TABLE REBUILD UNUSABLE INDEX
and then I tried ALTER TABLE xxx REBUILD UNUSABLE INDEX and it still did not work.

Eventually I used dynamic SQL to do them one at a time. What was I doing wrong?

Thanks,
Nirasha

I remember you can rebuild local indexes
one partition once only.

So it is against one partition.

alter table xxx modify partition xxx_part1 rebuild unusable local indexes;

I just saw this :
REBUILD UNUSABLE LOCAL INDEXES rebuilds the unusable local index subpartitions associated with subpartition

but my table was not partitioned. I did not try with alter table xxx rebuild unusable local indexes.

DO you think it would have worked had I typed it in like that, or is this specific to partitioned tables???

Thanks,
Nirasha

"DO you think it would have worked had I typed it in like that, or is this specific to partitioned tables??? "

I do not think so. Oracle will give you error message to complain about partition does not exist, or so error.