Eliminate Duplicates Using SQLLDR and/or .ctl file
From: gilgantic <gilgantic_at_yahoo.com>
Date: 15 Jul 2003 06:09:18 -0700
Message-ID: <d6052717.0307150509.33ee2a31_at_posting.google.com>
Is there anyway of eliminating duplicate entries as the database loads data using SQLLDR and/or .ctl (Control File)?
)
Date: 15 Jul 2003 06:09:18 -0700
Message-ID: <d6052717.0307150509.33ee2a31_at_posting.google.com>
Is there anyway of eliminating duplicate entries as the database loads data using SQLLDR and/or .ctl (Control File)?
I use the following command line using SQLLDR and a control file to load my data, but the sample.dat file has duplicate information. I would like to be able to eliminate this, since I have know ability to manipulate the sample.dat. ${ORACLE_HOME}/bin/sqlldr $USERPW /home/sample/sample.ctl
############# sample.ctl ###############
OPTIONS (DIRECT=TRUE)
LOAD DATA
INFILE '/home/sample/sample.dat'
truncate
INTO TABLE SAMPLE
NAME position(01:32) char,
EMAIL position(33:65) char
)
########################################
Thank You Received on Tue Jul 15 2003 - 15:09:18 CEST