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

Thread: Regd sqlldr-very urgent

  1. 08-30-2007, 12:23 AM #1
    orcl11
    orcl11 is offline Junior Member
    Join Date
    Aug 2007
    Posts
    1

    Regd sqlldr-very urgent

    Hi, I have 2 txt files say J1.txt, J2.txt,they are actually job file. now i have these files of data with a comma separated. Can some body tell me how to load these 2 txt files into 2 new tables? My question is, while creating the new 2 tables, shud the table columns be the same data types as that of the data in the text files? Please respond immediately. If so.... can some one write the scripts as an example and show me how to load these comma separated data files into tables.
    Reply With Quote Reply With Quote
  2. 08-30-2007, 03:50 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    whats wrong with the sql load manuals which have examples, and the examples that are delivered with your oracle installation?
    Reply With Quote Reply With Quote
  3. 08-30-2007, 11:34 AM #3
    rikfair
    rikfair is offline Junior Member
    Join Date
    Jan 2007
    Posts
    5
    Hi orcl11

    Have you considered using external tables to access the files directly?
    If it is an option check the following article for a simple example.

    http://www.astral-consultancy.co.uk/...doco.cgi?11210

    Hope it helps
    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