Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    23

    Unanswered: sql loader control files

    I have 2 control files taking records from 2 unrelated/different files into 2 seperate tables. Is it possible to create 1 big control file where the first file would load into the first table, a second file into a second table etc? At the moment the first file is loading into both the first and second tables. If this is possible could you post the relevent syntax

    many thanks

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    kerrie, Pretty sure that sql loader will only accept one input. It will, however, handle multiple outputs, i.e., save to multiple tables.

    The sql loader docs (http://download-west.oracle.com/docs.../ch10.htm#1656) might show different, but I'm almost 100% sure for your situation, you'll have to stick with the two control files.

    Hope this helps.

    JoeB

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Correct ... 1 input / controlfile ... should be the way to go ... gives you better control of the data ... Can go into multiple tables ....

    Gregg

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    if on unix/linux you could join the files with 'tee'

    cat file1 | tee -a file2


    then sqlload file2 to your two tables.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •