| 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
Go
on then Lisa, I rise to the challenge
<SPAN
class=223105213-25072001>
For us
UK based listers what is Vicodin?
<SPAN
class=223105213-25072001>
<SPAN
class=223105213-25072001>John
<FONT face="Times New Roman"
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]Sent: 25 July 01
15:26To: Multiple recipients of list ORACLE-LSubject:
RE: Data load options
Hi Sean,
Others have given you different
options. Here's some considerations:
1. SQL Script.
Can be SLOW
May require intermittent commits
in your script
Manual and error prone
Must go through SQL engine
2. SQL Loader
Can be very fast (direct -
bypassing SQL engine).
Direct path load will invalidate
indexes.
You can keep track of rejected
records easily (.bad file)
Dependent upon your file format
being EXACT, no errors.
3. Import
Requires minimal manual
fiddling
Can be very slow - I once imported
150GB and it took ~3 days
Does not seamlessly handle all
object types (INtermedia (domain) indexes is one example)
Restarting an import will take a
lot longer. If your import fails, be sure and truncate/drop all tables
before starting again.
Have the option of not including
indexes (INDEXES=N)
Can also reset your storage parms
prior to import (export with data=n, edit file [SSSHHH] and enter new
storage parms / import, export with data=y, import data with
IGNORE=Y)
I'm sure others will have additional
considerations to share. My choice has always been exp/imp.
Lisa Koivu <FONT
color=#0000ff face=Arial size=2>The Vicodin-enhanced DBA <FONT
color=#0000ff face=Arial size=2>Ft. Lauderdale, FL, USA
-----Original Message----- <FONT
face=Arial size=1>From: <FONT face=Arial
size=1>O'Neill, Sean [SMTP:Sean.ONeill_at_organon.ie] <FONT
face=Arial size=1>Sent: <FONT face=Arial
size=1>Wednesday, July 25, 2001 6:16 AM <FONT face=Arial
size=1>To: <FONT face=Arial
size=1>Multiple recipients of list ORACLE-L <FONT face=Arial
size=1>Subject: <FONT
face=Arial size=1>Data load options
I'm trying to compile a list of options for
loading data into an Oracle database on
NT platform. What I've come up with so far is: <FONT
face=Arial size=2>[1] SQL script that performs inserts, updates.
[2] SQL Loader utility <FONT
face=Arial size=2>[0%] OCP Oracle8i DBA <FONT face=Arial
size=2>[0%] OCP Oracle9i DBA <FONT face=Arial
size=2>-------------------------------- ------------ <FONT
face=Arial size=2>Organon (Ireland) Ltd. <FONT face=Arial
size=2>E-mail: sean.oneill_at_organon.ie [subscribed: Digest
Mode]
 |
 |