Re: need help with txt to oracle import

From: Kishore H <khejmady_at_melstar.com>
Date: 22 Dec 2002 23:00:58 -0800
Message-ID: <ed8ee3e4.0212222300.75fb453b_at_posting.google.com>

create a control file as follows. give it any name as sqltest.ctrl Content of the control file

---

load data
infile '<path and file name of data file>' --GIVE THE PATH AND FILENAME HERE
append into table Indexs
fields terminated by ","
(

   indate 	date "DD-MM-RR",
   indexs 	integer external,
   volume 	integer external

)

run the following command (after necessary changes) from the path where it is accessable.
sqlldr userid=<userid/passwd[_at_connectstring]> control=<control file name along with path> data=<data file name along with path>

A log file will be created with the name of your data file and extension .log. errors if any while loading the data will be written to this file.

Regards
Kishore H

"user" <utagi_at_yahoo.com> wrote in message news:<3dfabcf1_2_at_news.tm.net.my>...
> create table Indexs
> ( indate date not null constraint Index_Date_PK primary key,
> indexs number(8,2) not null,
> volume number(8,2) not null);
>
> alter session set NLS_DATE_FORMAT='<DD-MM-YY>';
>
> THESE ARE THE commands that i run before i import ... the text file context
> is like below:
>
> 29-06-00,830.2500, 237.0000
> 30-06-00,833.3700, 160.0000
> 03-07-00,793.9300, 104.0000
> 04-07-00,807.8700, 89.0000
> 05-07-00,818.6900, 95.0000
> 06-07-00,815.6800, 95.0000
> 07-07-00,820.4700, 135.0000
> 10-07-00,837.5900, 206.0000
>
> can anyone tell me how should i import them to my oracle ?
> i've tried sqlldr , but it seems that my oracle does have it, it says
> "SP2-0042: unknown command "sqlldr" - rest of line ignored."
>
> using oracle8i (8.1.7) personal edition on winxp
>
> thanks
Received on Mon Dec 23 2002 - 08:00:58 CET