DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql loader

  1. #1
    Join Date
    May 2001
    Location
    Columbus OH
    Posts
    10

    Question

    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

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  3. #3
    Join Date
    May 2001
    Location
    Columbus OH
    Posts
    10
    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
  •  


Click Here to Expand Forum to Full Width