|
It's a pain-killer:
BTW, in the US, a lot of Hollywood stars are in
rehab due to the addictive effects of this drug.
Defry
----- Original Message -----
Sent: Wednesday, July 25, 2001 11:25
AM
Subject: RE: Data load options
Cheers John, I was on the verge of asking
myself
Go
on then Lisa, I rise to the challenge
For us UK based listers what is
Vicodin?
John
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
The Vicodin-enhanced DBA
Ft. Lauderdale, FL, USA
-----Original Message-----
From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 6:16 AM
To: Multiple recipients of list ORACLE-L
Subject:
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:
[1] SQL script that performs inserts, updates.
[2] SQL Loader utility
[3] Import utility
Are there others?
Anyone care to share experience based opinions on pros and cons
of the
methods?
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
-------------------------------- ------------
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED] [subscribed: Digest
Mode]
Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
"Nobody loves me but my mother... and she
could be jivin' too." - BB King
--
Please
see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill,
Sean
INET:
[EMAIL PROTECTED]
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:
[EMAIL PROTECTED] (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).
**********************************************************************
This
email and any attachments may be confidential and the subject of
legal
professional privilege. Any disclosure, use, storage or copying
of this
email without the consent of the sender is strictly prohibited.
Please
notify the sender immediately if you are not the intended
recipient and
then delete the email from your inbox and do not
disclose the contents
to another person, use, copy or store the
information in any medium.
**********************************************************************
The information contained in this communication
is
confidential, is intended only for the use of the recipient
named
above, and may be legally privileged. If the reader
of this message is not
the intended recipient, you are
hereby notified that any dissemination,
distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this
communication to the sender and delete the
original message or any copy of
it from your computer
system.
|
