After dropping a partition, will Oracle automatically reuse deleted index entries?
I am dropping large partitions, and running dbms_part.cleanup_gidx is taking several days to complete. I want to avoid rebuilding indexes if possible.
I'm not particularly interested in reclaiming space - nice if I can do it, but the cost seems too great. The tables will keep growing at constant rates - so if deleted index entries are automatically overwritten/reused that would be great.