Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    here
    Posts
    19

    Unanswered: SQL Loader problem

    Need help resolving a SQL Loader problem. The error message I'm getting states the folling:

    SQL*Loader-510: Physical record in data file (yadayadayada) is longer than the maximum(1048576)
    SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

    Now my file structure is similar to the following

    1,12345,"Data",1,24,5000,20000201,|
    2,67890,"Data",1,24,5000,20000301,|

    etc....

    Not sure why I'm getting this but I can tell you that this file is pretty larger but the error seemed to indicate a line size problem rather then a record.

    Any help would be appreciated. thx in advance.
    Program, that's what I do.

  2. #2
    Join Date
    Jul 2003
    Location
    here
    Posts
    19

    Resolved ... My bad.

    brain fart...
    Program, that's what I do.

  3. #3
    Join Date
    Feb 2004
    Posts
    7
    Give snapshot of data and your control file first

Posting Permissions

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