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

    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.

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

  2. #2
    Join Date
    Sep 2003
    Virginia, USA
    Your friend was correct, SQL*Loader is the right tool. See documentation at

    In order to access the documentation, you must login to the Oracle Technet web site. If you don't login, the URL will hang.
    Author, Oracle Database 10g: From Nuts to Soup

Posting Permissions

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