Partition Exhange?
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.
I remember when this place was cool.