sql*loader limitations
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql*loader limitations

  1. #1
    Join Date
    Feb 2001
    Posts
    114
    hello ,
    is there a limit in sql loader with 256 characters ?
    How to load a field greater than 256 char ?

    thanks


  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    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
  •  



Click Here to Expand Forum to Full Width