Hydrocodone & Acetaminophen. Pain reliever for DBA's most probably; at present
jobsite we get dosage of Prosac when we swipe our access badges.
- Hallas John <John.Hallas_at_btcellnet.net> wrote:
> Go on then Lisa, I rise to the challenge
>
> For us UK based listers what is Vicodin?
>
> John
>
> -----Original Message-----
> Sent: 25 July 01 15:26
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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-----
> Sent: Wednesday, July 25, 2001 6:16 AM
> To: Multiple recipients of list ORACLE-L
>
> 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
> <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
> <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.
> **********************************************************************
>
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johan Muller
INET: bad_dba_at_yahoo.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 Wed Jul 25 2001 - 09:29:40 CDT
