Re: What is a best way to load large amount of data?
Posted by:
Adam D
Date: May 03, 2006 06:12PM
Without timing the two I cant say which is faster, but, I dont really like the alter table way as you dont really get a progress indication. I have the table created and use insert statements which contains many rows, (i dump using max_allowed_packet = 8M) This way I can select count(1) from table; to see how far along things are etc.
Subject
Views
Written By
Posted
1722
May 03, 2006 04:00AM
Re: What is a best way to load large amount of data?
1163
May 03, 2006 06:12PM
1252
May 04, 2006 01:05PM
1287
May 04, 2006 01:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.