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

Thread: Is there any limitations for SQL*Loader?

  1. 04-04-2002, 07:12 AM #1
    aj_usa
    aj_usa is offline Junior Member
    Join Date
    Dec 2001
    Posts
    96
    Hello all,

    In a Table called SEQ , we have one attribute called Nucl.

    This attribute is more than 4000 bytes long. The problem comes now. We used varchar2 but it doesnot take more than 4000 bytes. The problem is that, the sequence is more than 4000 bytes.

    We have tried with CLOB, but it fails to dump the entire data in to the table SEQ, ie when we try to load the data by
    SQL *LOADER in to the column Nucl. can you suggest some alternative to load huge data in to the columns of a table , any procedure we have to follow to do this task. Please suggest me one good solution.

    Thanx

    Reply With Quote Reply With Quote
  2. 04-04-2002, 10:34 AM #2
    aj_usa
    aj_usa is offline Junior Member
    Join Date
    Dec 2001
    Posts
    96

    Unhappy

    HELP PLEASE
    Reply With Quote Reply With Quote
  3. 04-04-2002, 11:50 AM #3
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    http://technet.oracle.com/docs/produ.../ch04.htm#8383

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  4. 04-05-2002, 06:31 PM #4
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Post your SQL*LOADER control file here.
    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