You can also use sql*loader with the direct path and
nologging functionnality.
--- "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> a écrit : >
Why not using bulk inserts in Oracle 8.x?
>
> Import is nothing more than array inserts.
>
> -----Original Message-----
> Sent: Wednesday, August 16, 2000 10:46 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I can't find the answer to this question in the
> Oracle documentation, so I
> thought maybe this list could help.
>
> We are working on a load process that currently
> creates about 6Gig of redo.
> The process loads flat files into temp tables and
> then processes them into a
> schema. I am suggesting the work be done on another
> instance which is not
> in archive mode, and the results be EXP/IMP to
> production.
>
> How are imports written to the redo logs? Would the
> result of the import
> write about the same amount of data as straight
> insert statements? My gut
> tells me no, but and direction as to the answer
> would be appreciated.
>
> Steve Monaghan
> Oracle DBA
> MSC Industrial Direct Co., Inc.
> Melville, NY
> MonaghaS_at_mscdirect.com
>
> --
> Author: Steven Monaghan
> INET: MonaghaS_at_mscdirect.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).
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Received on Thu Aug 17 2000 - 02:47:45 CDT
