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

Thread: SQL Loader limitation to varchar or char ?

  1. #1
    Join Date
    Jan 2006
    Posts
    2

    SQL Loader limitation to varchar or char ?

    Hello

    We are working on Oracle 9i database.
    We have to load lots of records from an external file and one of the field contains a number of characters > 10000 .
    the target table contains a long field to receive this data.

    i have tried to load this records but when the number of char exceeded 4821 chars no data are visible throw a select query (with Toad Developper)

    here is a sample of my CTL file
    Code:
    Load DATA
    INFILE "/export/home/crm2adm/scripts/head.tempLIGHT3"
    REPLACE INTO TABLE SW_OPPORTUNITY_LONG_WORK
    fields terminated by "ยง" 
    -- optionally enclosed by "'"
    TRAILING NULLCOLS
    (
    SWCUSTOMERID
    ,SWREASONCLOSED CHAR(10005) NULLIF SWREASONCLOSED=BLANKS
    Description of my table
    Code:
    CREATE TABLE CRMADM.SW_OPPORTUNITY_LONG_WORK
    (
      SWCUSTOMERID    VARCHAR2(10 BYTE)             NOT NULL,
      SWREASONCLOSED  LONG
    )
    Can someone can help us ?
    thanks a lot.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Is it TOAD or what?

    Are you sure it's SQL*Loader and not TOAD?
    Did you get any errors in the SQL*Loader log file?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Tags for this 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
  •  


Click Here to Expand Forum to Full Width