sql*loader-524 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: sql*loader-524 error

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    65

    Question

    Hi
    I am trying to load data into a table rcv1 using sql*loader, but
    I keep getting the following error.

    SQL*Loader-524: partial record found at end of datafile (rcv1.ctl)

    ctl file is as below:
    LOAD DATA
    INFILE *
    BADFILE '/opt/../rcv1.bad'
    DISCARDFILE '/opt1/../rcv1.dsc'
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    (LOC_ID, RCV_DATE, MSG_ID,RCV_TIME, PHONE, UNWANTED, WHO)
    BEGINDATA
    S570-1234, 01-05-30, 11885, 11:12:40, 6109384567, =,ttyv


    Has any body come across this error !!
    Any ideas

    Thanks,
    nk



  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    make sure that you don't have any extra trailing spaces or lines beyond your file


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    65
    I check & rechecked
    But there is no space or line beyond the last text in the file.


    nk

  4. #4
    Join Date
    Nov 2000
    Posts
    65

    luck hit

    I just entered a couple of "return"(enter) at the end of the file.
    And then I could load data into the table !!!

    Is this a know oracle 8.1.5 bug?
    And ideas!

    thanks
    nk

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It was not a bug. The loader was looking for an end-of-file or end-of-line character to terminate the execution and since you didn't have it on the first time, it had given that error. Now the retun had placed the EOF and in turn it was happy to see the end-of-file termination at the end of your control file.

    Hope this would help you to understand it. IF you need more detail on how to write control file for the sql-loader, check http://technet.oracle.com and do a search on the sql*loader


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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