From mdefry@hotmail.com Wed, 25 Jul 2001 09:37:05 -0700 From: "Mustafa" Date: Wed, 25 Jul 2001 09:37:05 -0700 Subject: Re: Data load options Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Data load options It's a pain-killer:   http://www.painmanagementsolutions.com/products/vicodin/vicodin.html   BTW, in the US, a lot of Hollywood stars are in rehab due to the addictive effects of this drug.   Defry
----- Original Message -----
From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 25, 2001 11:25 AM Subject: RE: Data load options Cheers John, I was on the verge of asking myself   -----Original Message-----From: Hallas John [mailto:John.Hallas@btcellnet.net]Sent: 25 July 2001 15:57To: Multiple recipients of list ORACLE-LSubject: 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@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 The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -----Original Message----- From:   O'Neill, Sean [SMTP:Sean.ONeill@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@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@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@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. **********************************************************************The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying 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 computersystem.