-
In SQL*Loader (Oracle 8i), is it possible to load data from 2 data files into one database table. Check out this set up:
DATA FILES:
test1.txt
col name datatype
A char(1)
C char(1)
text2.txt
col name datatype
B char(1)
D char(1)
CONROL FILE:
...
INFILE "C:\test1.txt"
INFILE "C:\test2.txt"
...
insert into table TEST_TABLE
FIELDS TERMINATED BY ' '
(A,
B,
C,
D terminated by whitespace)
Is this possible or am I just going about it the wrong way? Should I just load the data into their own tables in the DB, and then put them together using SQL*Plus?
Thanks for your help!
Nick
Oracle Developer
-
No, it is not possible to combine two logical records (from two different files) into one phisical record to be inserted into database with SQL*Loader.
You'll have to use the other option (loding into two separate tables and then combine them).
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
That's what I thought... thanks for your time.
Oracle Developer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|