Re: sql*loader direct path loads

Darryl, then is it feasible to load the data and enable the PK, dump exceptions into the exception table, using the exception table, delete the dups when done?

joe

"Tappenden, Darryl" wrote:

> Hi all
>
> Is there a way of performing a direct-path load but enforce primary-key
> constraints.
> i.e duplicates are sent to the discard file, say, and not inserted.
> We will be loading 50-150 million rows but cannot guarantee no duplicates in
> the datafiles.
> Also, we will be appending 1-10 million rows and again cannot guarantee no
> duplicates in the datafiles.
>
> Thanks in advance,
>
> Darryl Tappenden
>
> Oracle Database Administrator
> LloydsTSB Bank Plc. Red Lion Court, London, England
> email: darryl.tappenden_at_lloydstsb.co.uk
>
> ---------------------------------------------------------------------------------
> This e-mail is intended only for the above addressee. It may contain
> privileged information. If you are not the addressee you must not copy,
> distribute, disclose or use any of the information in it. If you have
> received it in error please delete it and immediately notify the
> sender.
>
> evolvebank.com is a division of Lloyds TSB Bank plc.
> Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS. Registered in
> England, number 2065. Telephone No: 020 7626 1500
> Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
> Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone
> No: 0131 225 4555
>
> Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
> Personal Investment Authority and represent only the Scottish Widows
> and Lloyds TSB Marketing Group for life assurance, pensions and
> investment business.
>
> Members of the UK Banking Ombudsman Scheme and signatories to the UK
> Banking Code.
> ----------------------------------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tappenden, Darryl
> INET: Darryl.Tappenden_at_lloydstsb.co.uk
>
> 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 Tue Oct 10 2000 - 14:58:27 CDT