Hi,

I have some partitioned aggregates tables.Every day before buliding the aggregates we truncate the partitions/subpartitions.After truncating the partitionons, index on those partitions/subpartitions tables were 'USABLE'.

I am not sure truncating the partions will disable/enablethe index.

Please help me out to resolve this issue.

Thanks,
Jai