2 INFILES for one control-file in SQL-loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 2 INFILES for one control-file in SQL-loader

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    182

    2 INFILES for one control-file in SQL-loader

    I want to load two flat-files (same format) into one table.

    I was just curious if somehow I can use the same control-file
    and just have two INFILEs

    ie:

    INFILE 'a.txt', 'b.txt'

    otherwise I'll just make two control files.

    thanks!
    - Cookies

  2. #2
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    Yes you can here is the syntax :

    load data
    INFILE 'a.txt'
    INFILE 'b.txt'
    insert into table ...
    ...
    Giani

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