sqlloader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sqlloader

  1. #1
    Join Date
    Feb 2002
    Posts
    25
    Hi,

    I am using sqlloader to load data into a table using this statement:
    sqlldr control=aging_ldr.txt userid=uname/pswrd1@database

    It works from other machines, and used to work from mine.
    But now I am getting this on my machine:

    SQL*Loader: Release 8.1.5.0.0 - Production on Thu Aug 1 16:25:29 2002
    (c) Copyright 1999 Oracle Corporation. All rights reserved.
    SQL*Loader-524: partial record found at end of datafile (aging_ldr.txt)

    Please help, Thanks in advance,

    Boris

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443

    Question

    Can you post a copy of your control file?
    is the name aging_ldr.txt?
    or did you misspell and correct name is aging_ldr.ctl?


  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443
    FROM METALINK Note:1058890.6

    Problem Summary:
    ================
    SQL*LOADER-524 USING SQL*LOADER

    Problem Description:
    ====================
    You are running either direct or conventional load and get the following error:

    LDR-524: partial record found at end of datafile

    This same controlfile and datafile works on Oracle Release 7.3.X - 8.0.4 but
    gives LDR-524 on Oracle Release 8.0.5.0 and 8.1.5.

    You have tried to look for this error in the manual and there is no description
    except for SQL*Loader chapter of the 8.1.5 version of the "Oracle8i Error
    Messages" book where this error is documented for the first time.


    Problem Explanation:
    ====================
    You may have hit bug:735710

    SQL*LOADER reports SQL*LOADER-524:PARTIAL RECORD FOUND AT END OF DATAFILE
    when the last record in the data file is missing a linefeed character.

    Oracle 8.0.5 introduces new OSD functionality for SQL*Loader that would cause
    this problem. The new functionality strictly checks the file format, therefore
    LDR-524 is signalled.


    Problem References:
    ===================
    bug:735710

    Search Words:
    =============
    LOADER SQLLOADER SQLLDR

    Solution Summary:
    =================
    ADD A LINEFEED

    Solution Description:
    =====================
    Ensure that a linefeed exists after the end of the last line in the SQL*Loader
    control file, datafile and parfile.

    Follow these steps to correct the problem:

    1. Using a text editor, binary file editor, or a hex editor, you append
    a linefeed character to the end of the last line in the SQL*Loader control
    file, datafile and parfile..

    i. text editor (eg. vi, ed, edit, etc)
    - hit the return / enter key while at the end of the last line in the
    file

    ii. binary / hex editor (eg. tr, hexedit, etc)
    - append hex value 0A ( decimal value 10 ) to the end of the file

    NOTE: Using NOTEPAD will not work.

    2. Save the file.

    3. Re-run SQL*Loader using the edited files.

    Solution Explanation:
    =====================
    SQL*Loader uses the newline / linefeed character to delimit instructions in
    the environment files. The lack of this control character causes SQL*Loader to
    report a read failure on the last line of the file since it requires the
    newline / linefeed character to consider a line read complete.
    .

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