RE: SQL*Loader - append to a table while checking column against another table

If you load your data into a table with an enable foreign key, it will be checked on the fly by SQL*Loader with the conventional path. In direct mode it disables constraints, and I am unsure whether it checks them when reenabling them (something which you can optionally get); any way it would let you with the manual check to do. If your CSV file is not in the million of rows or more range, I would go for SQL*Loader with the conventional path.

HTH SF

>----- ------- Original Message ------- -----
>From: "Saira Somani-Mendelin"
><saira_somani_at_yahoo.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Thu, 14 Aug 2003 05:44:23
>
>List,
>
>I have been given a csv file to load into an Oracle
>table. This table
>has no referential integrity constraints (it is
>checked via the
>application) so I could end up inserting a bogus
>record.
>
>Is there any way for me to check for the existence
>of a record in
>another table while loading data using SQL*Loader?
>
>
>Here's the process I use right now:
>
>Load records into a temporary table.
>Query these records against the reference table.
>If record doesn't exist, spool it into a file, give
>it back to the BA,
>get them to fix it, then go through the whole
>process again until there
>are no bad records.
>
>Seems like a roundabout way to do things - it
>definitely works for me
>but I just wonder if there is an easier way.
>
>Thanks in advance,
>Saira
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).