Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQLLDR

SQLLDR

From: Craig Ballingall <craig.ballingall_at_talk21nospam.com>
Date: Sat, 1 Dec 2001 18:13:44 -0000
Message-ID: <3c091dd6_1@mk-nntp-1.news.uk.worldonline.com>


Hi all

I have a batch prossing system based on 8.1.6.2.0 and I am having trouble with SQLLDR. The control file has 3 sectiojns to it with where clauses to define with table the data is loaded into depending on a key in the record. We are now getting some duplicates where we shouldnt and the PK bins the second record as it should but the second section of data appears to load twice.

I'm stumped and wonder if any of you have seen this before

Cheers in advance

Craig Ballingall
Oracle DBA
Audatex UK Received on Sat Dec 01 2001 - 12:13:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US