need help with txt to oracle import

From: user <utagi_at_yahoo.com>
Date: Sat, 14 Dec 2002 13:34:09 +0800
Message-ID: <3dfabcf1_2_at_news.tm.net.my>



create table Indexs
[Quoted] [Quoted] ( indate date not null constraint Index_Date_PK primary key,   indexs number(8,2) not null,
[Quoted]   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 [Quoted] 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 Sat Dec 14 2002 - 06:34:09 CET

Original text of this message