Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2003
    Posts
    11

    Unanswered: How to import .CSV file into Oracle9i Database

    Hi,

    How can I import a *.CSV file into oracle9i database?
    I would prefer to use sqlplus to load the data in however i will also be glad to use tools.i do not have Oracle management server installed,therefore i can't use dbastudio.

    thanks and regards.

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    Hi

    See http://askremi.ora-0000.com/question/show?id=318027 for a detailed description of loading an excell file (CSV) file in an oracle table.


    Good luck!


    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Mar 2003
    Location
    Belgium
    Posts
    9

    Re: How to import .CSV file into Oracle9i Database

    Originally posted by jeyagowri
    Hi,

    How can I import a *.CSV file into oracle9i database?
    I would prefer to use sqlplus to load the data in however i will also be glad to use tools.i do not have Oracle management server installed,therefore i can't use dbastudio.

    thanks and regards.
    Use SQL Loader or UTL_File Package. With 9i, you can create a table based on an external file. The system will use sql loader to load the data. The system will upload the data automatically. This is one of new features of 9i.

  4. #4
    Join Date
    Mar 2003
    Location
    Duesseldorf, NRW, Germany
    Posts
    3

    Re: How to import .CSV file into Oracle9i Database

    Originally posted by jeyagowri
    Hi,

    How can I import a *.CSV file into oracle9i database?
    I would prefer to use sqlplus to load the data in however i will also be glad to use tools.i do not have Oracle management server installed,therefore i can't use dbastudio.

    thanks and regards.
    Hi,

    try the sql loader it is in your oracle_home\bin directory. Look here for more details http://www.orafaq.com/faqloadr.htm#WHATIS

  5. #5
    Join Date
    Feb 2003
    Location
    AU
    Posts
    19
    sql*loader's the old school way of doing this. but if you'd like the added functionality of sql*plus for help in your loading mechanism (eg. if you need to insert/verify foreign keys) then the external tables extension to loader that's available in 9i is ideal.

    eg.

    CONNECT sys/manager AS SYSDBA;

    CREATE OR REPLACE DIRECTORY dat_dir AS 'C:\Oradata\Data';
    GRANT READ ON DIRECTORY dat_dir TO username;

    CREATE TABLE extauth (
    authno NUMBER(8),
    author VARCHAR2(50),
    accuracy NUMBER(8,2))
    ORGANIZATION EXTERNAL (
    TYPE oracle_loader
    DEFAULT DIRECTORY dat_dir
    ACCESS PARAMETERS (
    RECORDS delimited by newline
    LOGFILE dat_dir: 'extauth.log'
    BADFILE dat_dir: 'extauth.bad'
    FIELDS terminated by ','
    OPTIONALLY ENCLOSED BY '"'
    MISSING FIELD VALUES ARE NULL
    (authno,
    author,
    accuracy))
    LOCATION ('authoreg.dat'))
    PARALLEL 4
    REJECT LIMIT UNLIMITED;

  6. #6
    Join Date
    Nov 2009
    Posts
    8
    hi..i cant open the link u given.

    i also face the same problem.
    i have csv file and succesfully load the file into stringgrid in delphi 7. now i want this csv file insert into table.i'm using oracle 9i.plz give some guide to start....

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    This is the Oracle 9i SQL*Loader book. Check what's in there (you'll find many examples) and try to load data you have. In a case you don't succeed, do come back, explain what you have done and what Oracle has said about it.

  8. #8
    Join Date
    Nov 2009
    Posts
    8
    i'm looking at it n thanks...
    if i dun understand i'll go straight to u

  9. #9
    Join Date
    Nov 2009
    Posts
    8
    this is the way to insert csv to table?
    what i means is there ways@ programming that can insert csv file to table in delphi application?any coding or tutorial suggestion?

Posting Permissions

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