SQL*Loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL*Loader

  1. #1
    Join Date
    May 2001
    Posts
    82

    I would like to create a SQL*Loader control file to import data from a comma delimited text file.

    The data has to be imported into many tables and the tables have one to many relationship.

    Eg: for one record in table X, I have many records in table Y and for one record in table Y, I have many records in table Z.

    How should I format the text file?

    What is the format for the SQL*Loader control file?

    Thank you.

    Share on Google+

  2. #2
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    below is the general format of the control file:

    +++++++++++
    LOAD DATA
    Infile [path & filename of .csv file]
    DiscardMax
    APPEND/INSERT/TRUNCATE
    Into table [table name]
    Fields Terminated By ',' OPTIONALLY ENCLOSED BY '"'
    [Field names separated by commas]
    +++++++++++


    There are more parameters you can add to the control file. Visit the site below for more details.

    http://technet.oracle.com/doc/server...ch03.htm#11662
    leonard905
    leonard905@yahoo.com
    Share on Google+

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