Hallo,
We use partitioned tables in our production database which is Oracle 11g 64 bit. We use range partitioning based on date and hence a new partition for every day. Now comes the point of dropping older partitions say 6 months old. We have user defined scripts which exports the older partitions to a tape/disk and drops them from the table. I would like to know whether any other possible way to drop these partitions automatically - i believe Enterprise Manager does not have this option so is there any other tool supported by Oracle which does this? How do you people manage your partition deletion/drop in general??
Thanks in Advance.
Regards
AG