Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    san jose, CA
    Posts
    68

    Unanswered: How to load a talbe in SQL?

    Dear dBforums memebers:

    I want to know how to load a table in SQL*Plus environment.

    I created a table called author(author_name char(30) ). Instead of using single INSERT statement. I want to load table with a datafile, or a script file.


    Could someone tell me the procedure which will load a table using data file or a script file. My friend told me that SQL*Loader may do the job, but i couldn't find information on oracle website regrading this matter.

    Can anyone can give me some suggestions. I appreciate your help

    if possible, please show me a a detailed example, or web sources.

    sjgrad03
    12-20-03
    Last edited by sjgrad03; 12-18-03 at 14:31.

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    Your friend was correct, SQL*Loader is the right tool. See documentation at http://download-west.oracle.com/docs...rt2.htm#436160

    In order to access the documentation, you must login to the Oracle Technet web site. If you don't login, the URL will hang.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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