How to load tab separated,tab delimited datafile with SQLLDR
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to load tab separated,tab delimited datafile with SQLLDR

  1. #1
    Join Date
    May 2009
    Posts
    3

    How to load tab separated,tab delimited datafile with SQLLDR

    Hi,
    I need to load some data using SQLLDR. It is a .txt file with tab delimited data and the data file may contain tabs or spaces within column data. Cld anyone suggest how it can be loaded? Thanks.
    e.g.
    EmpID EmpName EmpAdd1 EmpAdd2
    1000 SAM KING SUITE 5 JOHNSON CITY TX
    where EmpId = 1000
    EmpName SAM KING(tab/space separated)
    EmpAdd1 SUITE 5 JOHNSON CITY (tab/space separated)
    Emp Add2 TX

    What it is currently doing is loading 'SAM' in the EmpName and 'KING' in the EmpAdd1 which is what I dont want. Pls suggest.

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

    Cool Suggestion

    We suggest you:

    1) Post the description of the target table
    2) Post the sql loader control file
    3) Post the exact sample data using "code" tags to preserve formatting

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    May 2009
    Posts
    3

    Smile

    I got the delimiter changed and solved this. Thanks.

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