Hi all,
I am trying to drop some partitions on several tables in my database. These tables generally have ~50,000 range partitions. When I ran my script to drop ~ 30,000 partitions in our dev db, it took about 2 hours to complete. Now in our production db, I am running a single drop command and its just hanging and hanging. Any ideas how I can dig deeper to find out why the different results? Running Oracle 11.2 on RHEL5.
Thank you,
Scott
alter table events_sup drop partition evt_15apr2012_0600_0615;