Re: What's quicker, table to table insert or extract and sqlload?
Date: 1996/02/09
Message-ID: <4ffq00$gen_at_news.sas.ab.ca>#1/1
>> Andy Hardy (aph_at_ahardy.demon.co.uk) wrote:
>> : 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?
Have you considered just doing a simple export of the table and its data, and then importing the table data into another schema? A synonym can be created to make it look like it is in any schema you want after it has been created.
I would think that Oracle's import facility is pretty fast. Disable your indexes/triggers etc to achieve optimal load speed.
//Dave Received on Fri Feb 09 1996 - 00:00:00 CET