Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    32

    Unanswered: Difficult in using sqlloader

    i am using sqlloader to load a plain text but i found that the row size seems to be over the limit. I would like to know set the size and what is the upper limit of the row in oracle table

  2. #2
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi,
    It is not clear to me. could u pls. send me the CTL file & the tablestructure where u r loading into. Also, possibly a row of the text file. I hope i would able to help u as i hv tried many things in sqlldr. Pls. send & i will try my best to help u.

    Regadrs,
    Kamesh Rastogi
    - KR

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    well, how long is your maximuym rowsize?
    you don't say.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Quote Originally Posted by alfredfong
    i am using sqlloader to load a plain text but i found that the row size seems to be over the limit. I would like to know set the size and what is the upper limit of the row in oracle table
    In Oracle 9i and above you can have VARCHAR2(4000) for VARCHAR2 datatype (4000 bytes). The NUMBER datatype is still the same. For CLOB, BLOB and BFILE datatypes the limit is 4 Gb.


    HTH,

    clio_usa - OCP 8/8i/9i DBA

  5. #5
    Join Date
    Jan 2004
    Posts
    9
    If you want a bit more control over the import process you can consider using SQL*XL. It works from within Excel and lets you load data straight from Excel into Oracle.

    Have a look at SQL*XL at www.oraxcel.com

    Gerrit-Jan Linker
    Linker IT Consulting Limited
    www.oraxcel.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •