OraFAQ Forum: Server Utilities » SQL*LOADER-350 TOKEN LONGER THAN MAX ALLOWABLE LENGTH OF 258 CHARACTERS

Home » RDBMS Server » Server Utilities » SQL*LOADER-350 TOKEN LONGER THAN MAX ALLOWABLE LENGTH OF 258 CHARACTERS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*LOADER-350 TOKEN LONGER THAN MAX ALLOWABLE LENGTH OF 258 CHARACTERS [message #72674]

Fri, 29 August 2003 03:20

John Owen
Messages: 1
Registered: August 2003

Junior Member

Hi all

Getting the following message when trying to load data.
SQL*LOADER-350 TOKEN LONGER THAN MAX ALLOWABLE LENGTH OF 258 CHARACTERS
I am performing the decode function on one of my columns and it does exceed 258 characters in length.

Does any one if I can split the decode into 2 or three smaller tokens, or do I have to split the .CTL file into 2 or 3 separate load statements with where clauses.

Cheers
JOHN

Report message to a moderator

Re: SQL*LOADER-350 TOKEN LONGER THAN MAX ALLOWABLE LENGTH OF 258 CHARACTERS [message #72675 is a reply to message #72674]

Fri, 29 August 2003 06:29

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please post your control file~

Report message to a moderator

Re: SQL*LOADER-350 TOKEN LONGER THAN MAX ALLOWABLE LENGTH OF 258 CHARACTERS [message #122382 is a reply to message #72675]

Mon, 06 June 2005 05:11

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Here are some possible solutions:

1. Make the token shorter by removing all spaces, use shorter column names, etc.

2. Create a database function containing the token expression and call it from the sqlldr control file.

3. Load the data into a temporary table first, and fix the data with a SQL script afterwards.

Best regards.

Frank

Report message to a moderator

Re: SQL*LOADER-350 TOKEN LONGER THAN MAX ALLOWABLE LENGTH OF 258 CHARACTERS [message #122533 is a reply to message #122382]

Tue, 07 June 2005 01:34

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

A good referral in ur case....
http://www.orafaq.com/forum/t/46976/70132/

Report message to a moderator

Previous Topic:	Loading data into table using SQL*Loader
Next Topic:	how to export tables from Foxpro & import to Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:35:29 CDT 2024