SQL LOADER HELP HELP HELP

From: Claudio Lombardo <clombardo_at_bsc.it>
Date: Thu, 30 Sep 1999 13:59:16 +0200
Message-ID: <7svje0$4ac$1_at_nslave1.tin.it>

Hi everybody,
[Quoted] I have to load a lot of ascii files written like the following example:

0|2048|1008|0|Rete12|010|09/28/1999 01:00:37 GMT+02:00|09/28/1999 01:55:37 GMT+02:00
0|2048|1008|0|Rete12|010|09/28/1999 01:04:47 GMT+02:00|09/28/1999 01:59:48 GMT+02:00
1873|161|5485|0|Rete12|010|09/28/1999 01:02:37 GMT+02:00|09/28/1999 01:02:50 GMT+02:00
0|2048|1008|0|Rete12|010|09/28/1999 01:04:02 GMT+02:00|09/28/1999 01:59:02 GMT+02:00
0|2048|1008|0|Rete12|010|09/28/1999 01:04:01 GMT+02:00|09/28/1999 01:59:02 GMT+02:00 In Oracle 8.04 for NT I have defined the following table:

[Quoted] SrcPort     VARCHAR2(15)
DstPort     VARCHAR2(15)
TxBytes     NUMBER (15,0)
RxBytes     NUMBER(15,0)
Login         VARCHAR2 (30)

AcctNum NUMBER (5,0)
StartTime DATE
EndTime DATE.

I have tried to load via SQLLDR80 utility this data in my table (called "vu"), using this control file:

LOAD DATA
INFILE 'd:\temp\pippo.dat'
APPEND INTO TABLE MYUSER.VU
FIELDS TERMINATED BY '|'
(SRCPORT,

DSTPORT,
TXBYTES,
RXBYTES,

LOGIN,
ACCTNUM,
STARTTIME DATE "????????",
ENDTIME DATE "????????") How I have to substitute the "????" in order to load correctly the DATE information stored into ascii file (note that I need only date and time and not the GMT information).

Please answer as soon as possible... I'M DISPERATE!!!!!!

Thank you !

CLaudio

--
____________________________________

Claudio Lombardo

mailto:CLombardo_at_bsc.it

Received on Thu Sep 30 1999 - 13:59:16 CEST