Results 1 to 3 of 3

Thread: SqlLdr problem

  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: SqlLdr problem

    I Want to import dat file in to oracle using sqlldr application. I have written control file to import data. The following is hte control file code I have written
    OPTIONS (ERRORS=500000)
    LOAD DATA
    infile 'c:\temp\Duct_Section_Updated.dat'
    into table DUCT_SECTION
    FIELDS TERMINATED BY ','
    (
    ESTIMATE_DESCRIPTION CHAR,
    RECORDED_LENGTH "NUMBER",
    EXCHANGE_CODE CHAR,
    INSTALLATION_DATE CHAR,
    DISTRIBUTION_POINT_ID CHAR,
    COMMENTS CHAR,
    TRACK_ID "NUMBER",
    SECTION_NUMBER CHAR,
    ESTIMATE_ID "NUMBER",
    CALCULATED_LENGTH CHAR,
    PLANT_STATE_ATT CHAR,
    ID "NUMBER",
    KEYVAL CHAR
    )

    with this I am not getting any error but the data is not importing into the table. (the table is empty only this your information)
    Can anybody explain me the problem? thanks in advance

    Gopi Chand.V
    CAD/GIS Programmer.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: SqlLdr problem

    What does the log file say? (Cut and paste it here preferably)

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You might try to include .BAD file and .EXC (bad and exclude) files
    in your control file, change the number of errors to a SMALLER number
    (say 50 or so), rerun SQLLOADER and then you will have something
    that you can look at and determine where the problem is. Then
    post results here.

    HTH
    Gregg

Posting Permissions

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