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" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >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:[EMAIL PROTECTED]] > > 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:[EMAIL PROTECTED]] > > 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:[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. > > ********************************************************************** > > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).