Re: sqlldr problem a tough one???

From: Peter Shankey <shankeyp_at_{NO-SPAM}its.charlestoncounty.org>
Date: Fri, 03 Aug 2001 13:26:27 GMT
Message-ID: <20010803.13262700@its.charlestoncounty.org>

Yes, however, the load time will increase a lot as this file will need t o
be loaded on a weekly basis and the file will have about 220K lines.

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

On 8/3/01, 4:05:55 AM, "Kai Yuen Kiang" <kai kiang_at_cytecht.com> wrote regarding Re: sqlldr problem a tough one???:

> Can't you first manipulate the .dat file to join the date and time par
 ts
> together?
> This should be easily done by awk, Perl, or sed! So you may write a
 Master
> shell script that first call the awk script to modify the dat file int
 o a
> new dat file, then call the sqlldr to read in the new dat file as you
> normally do, then delete the temp new dat file. Job DONE! Oracle is n
ot
the
> whole world.
 

> --
> Best Regards,
> Kai Yuen Kiang
 

> MIS Analyst
> Cytech Technology Ltd.
> Tel: (852) 2378-2225
> Fax: (852) 2375-7700
> http://www.cytecht.com
> "Peter Shankey" <shankeyp_at_its.charlestoncounty.org> ?????
> 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 - 08:26:27 CDT