DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql*loader limitations

  1. 05-25-2001, 12:04 PM #1
    yenni143
    yenni143 is offline Member
    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

    Reply With Quote Reply With Quote
  2. 05-25-2001, 12:16 PM #2
    padmam
    padmam is offline
    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
    Reply With Quote Reply With Quote
  3. 05-25-2001, 12:40 PM #3
    santoshym
    santoshym is offline Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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