Sql Loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Sql Loader

  1. #1
    Join Date
    Apr 2001
    Posts
    112
    Can I specify multiple ctl files in the infile clause of sqlloader.
    I have 100s of files loading into one table. Is there an easy option to deal
    with this situation.

    Thanks

  2. #2
    Join Date
    Jun 2001
    Posts
    87
    Dunno about multiple control files but you can speed up inserts by using SQL loader direct path loading. By setting the unrecoverable option redo will not be generated therefore loading is faster. Don't forget to backup first.

  3. #3
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Multiple ctl files

    Hi Tansdot,

    If you are using a unix box you can cat your files into one large file.

    > cat file1 file2 ....file# > file_to_load

    You then can use one sqlloader ctl file.

    Greetings Tycho

  4. #4
    Join Date
    Jun 2001
    Posts
    87

    DAT file

    On NT you could also load all your data into a single DAT file and insert, append all the data from that one DAT file.

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