Toad World® Forums

ER: Show Unusable Indexes where one of its its Partitions is Unusable


#1

ER: Show Unusable Indexes where one of its its
Partitions is Unusable


#2

Hi Richard,

Sorry I didn’t respond to this sooner. This information is available
already in SB-Indexes-RHS (or Describe window) Partitions tab. If a partition is
unusable, you’ll see a red X next to the partition name in the grid.
It’s also brought to your attention in the alter index dialog, and
it’s in the ‘Invalid Objects’ tab too.

-John