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);
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