What's quicker, table to table insert or extract and sqlload?

Hi,

I've a 6 million row table that needs to be copied to another, to produce identical copies.

I'm contemplating either performing a very large insert (will I have the rollback to support it!) or extracting the first table to a file for subsequent loading by sqlload.

Any thoughts or suggestions?

Andy

-- 
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request
===============================================================
A physicist is an atom's way of knowing about atoms.
                -- George Wald