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