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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] 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: [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).
