| 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: ot: RE: Data load options vicodin
a HIGHLY addictive pain-reliever, I believe that more than 5 days on it is enough to addict someone.
I was given a prescription for this after knee surgery. I very reluctantly took half of one (I had read about how addictive it was) the first night after my surgery when I was going out of my head with pain. When half did not completely relieve the pain, I took the other half. Good thing I was in bed when I did that. I went out so fast I would have hit the floor if I had been standing up.
Never took another one
>From: "Koivu, Lisa" <lisa.koivu_at_efairfield.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: ot: RE: Data load options vicodin
>Date: Thu, 26 Jul 2001 07:47:05 -0800
>
>A pain reliever (narcotic) that makes you really woozy sleepy and stupid.
>Lucky I'm not actually supporting a database. I'm off the painkillers
>today, yesterday was bad . . .
>
>
>
> > -----Original Message-----
> > From: Hallas John [SMTP:John.Hallas_at_btcellnet.net]
> > Sent: Wednesday, July 25, 2001 10:57 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Data load options
> >
> > Go on then Lisa, I rise to the challenge
> >
> > For us UK based listers what is Vicodin?
> >
> > John
> >
> > -----Original Message-----
> > From: Koivu, Lisa [mailto:lisa.koivu_at_efairfield.com]
> > Sent: 25 July 01 15:26
> > To: Multiple recipients of list ORACLE-L
> > Subject: 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
> > The Vicodin-enhanced DBA
> > Ft. Lauderdale, FL, USA
> >
> > -----Original Message-----
> > From: O'Neill, Sean [SMTP:Sean.ONeill_at_organon.ie]
> > 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: sean.oneill_at_organon.ie [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: Sean.ONeill_at_organon.ie
> >
> > 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).
> >
> >
> >
> >
> >
> > **********************************************************************
> > 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.
> > **********************************************************************
> >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.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 Thu Jul 26 2001 - 12:42:20 CDT
 |
 |