Re: sqlldr problem a tough one???

From: Peter Shankey <shankeyp_at_{NO-SPAM}its.charlestoncounty.org>
Date: Fri, 03 Aug 2001 19:18:11 GMT
Message-ID: <20010803.19181100@its.charlestoncounty.org>

I tried that but it did not work. But perhaps I made a mistake.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 8/3/01, 10:54:35 AM, "Ranga Chakravarthi" <ranga_at_nospam.cfl.rr.com> wrote regarding Re: sqlldr problem a tough one???:

> Peter,

> A similar question was asked before.
> In your control file, just treat the two fields as one by using the da
te
> format like this :
> sdate date 'DDMONYYYY" "HH24:MI:SS'
> it will be okay as long as you have a fixed number of spaces between t
he
> end quote of the date field and the begin quote of the time field in y
our
> input file.

> HTH,
> Ranga Chakravarthi

> "Peter Shankey" <shankeyp_at_its.charlestoncounty.org> wrote in message
> news:20010802.19292000_at_its.charlestoncounty.org...
> I am having a sql loader problem (oracle 8.1.7) which I can not seem t
o
> figure out.

> the table looks like this:

> SQL> desc fwlog
> Name Null? Type
> -------------------------------
> SDATE NOT NULL DATE
> SERVICE varchar2(50)

> SOURCE VARCHAR2(15)
> DESTINATION VARCHAR2(100)
> USERID VARCHAR2(100)
> INFO CLOB

> SQL>

> The data is generally Variable-Length data this sample data may-be l
ine
> wrapping for you but each row is one line.

> "16Jul2001" " 8:07:48" "http" "208.161.140.43" "outpostrr1.real.co

m"

> "" " resource http://207.188.7.131:80/getlatest.glh"
> "16Jul2001" " 8:07:48" "http" "208.161.140.43" "207.188.7.36" ""
"
> resource
> http://207.188.7.36:80/issues/01/07/14/0/010706 bigbro krista.gd"
> "16Jul2001" "11:52:38" "http" "208.161.140.43" "www9.dcx.yahoo.com
"
> "" " resource http://64.58.76.178:80/"
> "16Jul2001" "13:50:22" "http" "208.161.140.43" "www2.yahoo.com" "
"
> " resource http://204.71.200.67:80/"

> my control file is

> LOAD DATA
> INFILE 'logfile.dat'
> DISCARDFILE 'logfile.dsc'
> APPEND
> INTO TABLE FWLOG
> FIELDS TERMINATED BY " " ENCLOSED BY '"'
> (
> SDATE DATE "DDMONYYYY'"' '"'HH24:MI:SS",
> SERVICE,
> SOURCE,
> DESTINATION,
> USERID,
> INFO
> )

> Now for my problem
> The problem I am having is in the dat file the date and time are broke
n
> up into two parts. I have tried twiddling with the control file in ord
er
> to get the first to dat file columns into the single date field howeve
r I
> have not had any success. I have tried
> SDATE DATE "DDMONYYYY\" \"'HH24:MI:SS",
> and many variation. If anyone has any ideas I would be most thankful

> thanks
> Pete
Received on Fri Aug 03 2001 - 14:18:11 CDT