HELP SQL*Loader Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: HELP SQL*Loader Error

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150
    I am trying you load a flat file to an oracle table with 23 Columns (number and varchar2 datatypes) using SQL Loader. The number of rows to be loaded is about 70K. I was able to use SQL loader to load data into other table, suddenly I received this type of error;
    -----------------------------------------------------------------
    SQL*Loader-00350 Syntax error at line 10.
    Token longer than max allowable length of 258 chars
    -----------------------------------------------------------------

    then it points the error on line of the control file.

    I tried looking the error code in Oracle Messages and codes but it gives a different description of the error.

    Ed

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Until controlfile structure and flat file data seen, difficult to give some suggestion. Is it loading some rows atleast or no rows. what do you get in bad file or log ?
    Reddy,Sam

  3. #3
    Join Date
    Feb 2001
    Posts
    1
    Could it be that the parameter for the column is not set correctly. You might want to limiting the data to be loaded into the column to be less than 256 character or set the column to LOB.


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