I suppose that "Insert into ... Select ..." is better.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Originally posted by mike9 I understood that you would have to split the partition(s) once you exchanged the partiton. But depending on how many partitons he wants to use it would probably use more time and ressources than simply inserting it once directly in the right partition.
I have to admit that I haven't tested it, if I got some time today I will do it
Mike
I doubt it. I'd like to see the numbers on that...