OraFAQ Forum: Server Utilities » field length issue

Home » RDBMS Server » Server Utilities » field length issue

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

field length issue [message #72050]

Wed, 26 February 2003 19:43

ram
Messages: 95
Registered: November 2000

Member

Hello,
I am trying to load data using the following ctl file

load data
infile 'description_test.txt'
badfile 'description_test.bad'
discardfile 'description_test.dsc'

insert
into table description_test
fields terminated by ',' optionally enclosed by '"'
(
item_id,
description
)

Description filed is 4000 C long

In my sample data, my description filed is less than 1000 characters, but still the loader is rejecting the records (Exceeds maximum length)

I generated the text file from an original excel file and the description text has many special characters.

I am able to update the table directly using sql navigator

Thank you for your help in advance
Ram

Report message to a moderator

Re: field length issue [message #72055 is a reply to message #72050]

Thu, 27 February 2003 05:55

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

Senior Member
Account Moderator

-- u can use substring...something like this
insert into table mytable
fields terminated by ',' optionally enclosed by '"' 
(
item_id,
description char "substr(:description,1,30)"
)

Report message to a moderator

Re: field length issue [message #72059 is a reply to message #72055]

Thu, 27 February 2003 11:13

ram
Messages: 95
Registered: November 2000

Member

Hello Mahesh,
My description filed can be 2000 char long

should my ctl be ..

insert into table mytablefields terminated by ',' optionally enclosed by '"' (item_id,description char "substr(:description,1,2000)")

Thank you in advance

Ram

Report message to a moderator

Previous Topic:	Importing Oracle Dump
Next Topic:	Improving the performance of Oracle Import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 09:45:10 CST 2025