-
hello ,
is there a limit in sql loader with 256 characters ?
How to load a field greater than 256 char ?
thanks
-
Inestigation in progress
Hi, 25th May 2001 21:50 hrs chennai
Limitation Condition==>Yes
http://www.csee.umbc.edu/help/oracle...28_01/ch04.htm
Investigation under progress
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
Hi
There is no limit on sql loader with 256 characters but only thing is you have to use the following option in control file
I have put a small example for you
OPTIONS (BINDSIZE=236441)
LOAD DATA
INFILE 'temp.dat'
INTO TABLE temp
FIELDS TERMINATED BY ','
(
fiend1 char(300)
)
Regards
Santosh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|