problem with loading long data using sqldr

[Faris Hussain]

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..

[harry d brown jr]

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

[A. Clay Stephenson]

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

[A. Clay Stephenson]

Hi Again:

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

[Faris Hussain]

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

[Andreas D. Skjervold]

Hi

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

Andreas