| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data load options
I forgot to add: there was a commit for every 1000 rows.
Jared
Denny
Koovakattu To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
<denny_vk_at_yaho cc:
o.com> Subject: Re: Data load options
Sent by:
root_at_fatcity.c
om
07/25/01 10:16
AM
Please respond
to ORACLE-L
At least she didn't have a commit after every insert and ask you to tune
the
database ;)
Denny
Jared.Still_at_radisys.com wrote:
>
> I will second Lisa's recommendations.
>
> If you have much data, and/or will be doing this frequently, SQL*Loader
> is your friend. It is very fast.
>
> Loading from a SQL script is very bad unless you have small amounts
> of data.
>
> I once worked with a duhveloper who could not be dissuaded from
> loading all data from SQL scripts. We're talking millions of rows
> here. A single 10 gigabyte SQL script of insert statements.
>
> She single handedly brought our DW to it's knee's. It begged
> for mercy. There was none. Duhveloper was fired. :)
>
> Jared
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: denny_vk_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jul 25 2001 - 12:16:55 CDT
 |
 |