Hi kids!

Anyone out there have direct experience with exchanging partitions?

Oracle 10.2
HP/UX

My apps team has a process where they load the latest monthly partition on a table by doing a select/ insert append on the same table. The problem is that one table in partitcular has 138+ million records, RI, and 17 indexes so this process takes 22 hours.

We kicked around a few ideas yesterday and came up with partition exchange which I will be playing with today if I have the time. Just wanted to see if anyone has used it successfully. I know we use it in house for DW but there is no RI in DW.