Inserting .txt file data into a table on 8i (8.1.6)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Inserting .txt file data into a table on 8i (8.1.6)

  1. #1
    Join Date
    Dec 2000
    Posts
    8

    Question

    I'm a newbee with oracle I'm using Oracle 8i (8.1.6) on win2kserver that I set up at my house to get ready for school jan 8 for DBA certification so I can practice at home.
    Here is my question.

    I have 4 .txt files with data (example of one is):
    A,25,100
    B,101,200
    C,201,1000
    This is the data in a .txt file that I have.
    I want to insert it into a table that I created with the consol manager and used the create tabel wizard called COSTCAT
    I have already created the tabels specifications like number, varchar2 for each column. Is there a way to import or load the data into the empty table that I have allready created and set up for that specific data. I created for different tables and each one is set up for that specific data .txt file that I want to put in the table. I tried to use the data management load wizard but I dont understand the part in the wizard were it asks me to specify the full path and name of the control file on the database server machine which is used to describe what will be loaded and how. If I already created the table with the imformation on how the table is to be set up how can I just transfer the data to each individual table for that txt file.
    Any help would be nice.
    Thanks in advance.
    Mark


    [Edited by clearview on 12-23-2000 at 12:06 PM]

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Hi,

    In order to load data from a text file to a table you use oracle provided utility SQL*Ldr. This utility takes your text file and also a control file which has the parameters to control the behaviour of the load:Like

    what it suppose to do if data is not formatted ?
    what it should do if one of the column to which you are loading doen't have a value ?
    what kinda load method(direct/conventional) it should use for load ?
    what if the record is bad...'

    ---
    ---

    and so on..

    So you have to give this ctl file also as input along with your text file as input.

    I am just giving high level information here. you better go thru documentation of Oracle Utilities(SQL Loader). I don't have actual syntax on top of my head thats why. Feel free to e-mail me if you need further information.


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