Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading records with time stamps
Hi,
Pl. use following control file to Load the data.
LOAD DATA
INFILE 'H:\LOGS\VOICE_DIAL\2001_06_07_VOICE_DIAL.DAT'
INTO TABLE TELCO.VOICE_DIAL
FIELDS TERMINATED BY ','
(CALLDATE DATE 'Day Mon DD HH24:MI:SS RRRR', CALLER, HOST, CALLED_NUMBER, DURATION)
With regards,
Chirag Shah
Oracle DBA
allan.tabilog_at_mailexcite.com (AT) wrote in message news:<d8adfa64.0106102205.3e6f8a73_at_posting.google.com>...
> Hi there,
>
> I'm trying to use sqlldr.exe to load the following row [just one
> sample row but I'm actually loading heaps of these]
>
> Thu Jun 07 18:13:25 2001, 25573557, 4734374, 044628314, 10.766
>
> into the table 'VOICE_DIAL':
>
> SQL> DESCRIBE VOICE_DIAL
>
> Name Null? Type
> ----------------------------------------- -------- ------------
> CALLDATE DATE
> CALLER NUMBER
> HOST NUMBER
> CALLED_NUMBER NUMBER
> DURATION NUMBER
>
> This is the control file:
>
> LOAD DATA
> INFILE 'H:\LOGS\VOICE_DIAL\2001_06_07_VOICE_DIAL.DAT'
> INTO TABLE TELCO.VOICE_DIAL
> FIELDS TERMINATED BY ','
> (CALLDATE, CALLER, HOST, CALLED_NUMBER, DURATION)
>
> After invoking sqlldr, it goes:
>
> E:\scripts>SQLLDR USERID=TIGGER/FOO_at_FOOBAR,
> CONTROL='E:\SQL\LOAD_VOICE_DIAL.CTL',
> DATA='H:\LOGS\VOICE_DIAL\2001_06_07_VOICE_DIAL.DAT'
>
> SQL*Loader: Release 8.1.6.0.0 - Production on Mon Jun 11 17:34:37 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Commit point reached - logical record count 1
>
> ...
> But nothing actually gets loaded and my row appears in the ".bad" file
> . I changed the first column to '06-JUN-01' and the row was loaded
> successfully.
> Now how can I tell sqlldr to look at the first column as a full
> time-stamp and load it in that format? I need to do this because my
> table has to store information on both the date and time that a call
> was made.
>
> environment:
> Oracle 8i Release 8.1.6.0.0
> Windows NT 4.0
>
> Thanks for any tips!
> - Allan
Received on Mon Jun 11 2001 - 07:50:15 CDT