Chuck Norris can scale beyond infinity.
Rather than me building an example and spoon feeding it to you, I suggest you find a copy of “Scaling to Infinity” by Tim Gorman. I believe that is the clearest explanation of partition exchange done well and any re-write I would do would probably be flawed by comparison.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com-- //www.freelists.org/webpage/oracle-l
