Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> append records from flatfile via SQLLDR ?
how does one append records from a flat file to an existing file that is already populated using SQLLDR?
I know the syntax for INSERTING records into a BLANK table:
LOAD DATA
INFILE '/dbraid/ida1-00/home/applmgr/fixed_assets.dat'
INTO TABLE apps.fixed_assets
(
dept INTEGER EXTERNAL TERMINATED BY ',' , asset_no INTEGER EXTERNAL TERMINATED BY ',' , description CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"', in_service DATE "DD-MON-RR" TERMINATED BY ',' , method CHAR TERMINATED BY ',' , yr_mo DECIMAL EXTERNAL TERMINATED BY ',' , cost DECIMAL EXTERNAL TERMINATED BY ',' , amount DECIMAL EXTERNAL TERMINATED BY ',' , depreciation DECIMAL EXTERNAL TERMINATED BY ',' , reserve DECIMAL EXTERNAL TERMINATED BY ',' , percent DECIMAL EXTERNAL TERMINATED BY ',' , t_f CHAR
but how can I modify this so that additional files can be processed later? Thanks, and sorry for the wordiness.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Jul 08 2000 - 00:00:00 CDT