in reply to Batch loading data into Oracle - Perl to the rescue!
As you said. You can have the data in a separate file You don't need to concatenate anything at all.
Create a separate control file 'n1822.ctl' like:
Point your loader command to that file like:
# sqlldr USERID=scott/tiger control='n1822.ctl' log='log.txt' bad='bad.txt' direct=true
/brother t0mas
Create a separate control file 'n1822.ctl' like:
LOAD DATA INFILE 'n1822.txt' INTO TABLE {table name} ( person_id POSITION(1:9) CHAR(9) surname POSITION(10:34) CHAR(25) given_names POSITION(35-59) CHAR(25) )
Point your loader command to that file like:
# sqlldr USERID=scott/tiger control='n1822.ctl' log='log.txt' bad='bad.txt' direct=true
/brother t0mas
|
---|
Replies are listed 'Best First'. | |
---|---|
Batch loading data into Oracle - my solution
by hotyopa (Scribe) on Jan 28, 2003 at 22:52 UTC |
In Section
Seekers of Perl Wisdom