Data load through Control File
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Data load through Control File

  1. #1
    Join Date
    May 2009
    Posts
    1

    Data load through Control File

    Hi,

    I have a sample DataFile.txt file which has two records of 7 fields each separated by "tab" delimiter.

    I want to load this file into Oracle Db by using the ctl file by name "World.ctl" into the sample table by name "World".

    Last two fileds will allow NULL values. please find the attachment.


    The contents of a ctl file is as below
    =====================

    LOAD DATA

    INFILE 'C:\ABCL\ABCDATA\DataFile.txt'

    INTO TABLE WORLD

    FIELDS TERMINATED BY x'09'

    LINES TERMINATED BY '\n'

    OPTIONALLY ENCLOSED BY '"'

    ===========================


    By using the above code i am not able to upload the data through control file. Is there any special line of code i have to write to control null values.

    i would be greteful if any one of you could please let me know the possible error behind the code?
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483
    Try adding:

    TRAILLING NULLCOLS
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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