topic Re: problem with loading long data using sqldr in Operating System - HP-UX

problem with loading long data using sqldr

Faris Hussain — Sun, 06 Jan 2002 09:28:38 GMT

Hi,
I am trying to load some data in to table which contains a long datatype. The data i am trying to load contains a column that is pretty large, some up to 8000 characters which should go into the long datatype column.

when i use the sqlldr it does not give any errors, but only loads around 100 characters to this column .

here is my control file:
LOAD DATA
INFILE 'entity3.dat'
BADFILE 'entity3.bad'
TRUNCATE INTO TABLE SONEDBA.ENTITY3
FIELDS TERMINATED BY "@"
TRAILING NULLCOLS
(ENTITY_KEY, ID, ENTITY_NAME, BITMAP,PRIMARY_KEY_COLUMN, LOCK_VERSION, SQL_STATEMENT CHAR (20000))

entity3.dat file, which contains the data holds a column which is around 8000 charcaters.

I checked the control file but no errors.
The long datatype is SQL_STATEMENT column.

Thanks for your help inadvance..

Re: problem with loading long data using sqldr

harry d brown jr — Sun, 06 Jan 2002 16:09:25 GMT

Faris,

have you looked into either writing a "c" or "perl" program to load your data? I think you are running into a command line IO length issue.

live free or die
harry

Re: problem with loading long data using sqldr

A. Clay Stephenson — Sun, 06 Jan 2002 19:42:54 GMT

I assume that there are no '@'s within the SQL statements. You might try adding the 'optionally enclosed by '"' clause.

e.g.
FIELDS TERMINATED BY '@' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS

Re: problem with loading long data using sqldr

A. Clay Stephenson — Sun, 06 Jan 2002 20:20:15 GMT

Hi Again:

I also suggest that you search Oracle's MetaLink. There are a number of posting with problems very similar to yours.

Re: problem with loading long data using sqldr

Faris Hussain — Mon, 07 Jan 2002 01:55:21 GMT

Well,, i did try the optinally clase but did not work.
also, i set the bindsize to 20000 still have the same problem

Re: problem with loading long data using sqldr

Andreas D. Skjervold — Tue, 15 Jan 2002 09:12:23 GMT

Hi

No errors you say?? What about the .log file. Can you post it here?

Andreas