Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlloader

Re: sqlloader

From: Steve Blomeley <steveblomeley_at_yahooDOTco.uk>
Date: Fri, 16 Mar 2001 00:54:59 +0000
Message-ID: <3AB16463.32AF93B3@yahooDOTco.uk>

Xavier Pioche wrote:
>
> Hi,
> is it possible to pipe data directly to sqlloader ? does anyone have test to
> insert syslog data into a database?
> thx

I guess you could create a FIFO file that you use as the data file of an SQLLoader session, then pipe your syslog to the FIFO. Something along the lines of...

$ mknod syslog.dat p
$ sqlldr data=syslog.dat control=... userid=...
$ tail /wherever/syslog > syslog.dat

I seem to recall doing something similar with import/export - You might have to play around with this to get it working, but it should be possible... May want to run the sqlldr and tail commands in the background. And the mknod and tail commands might not have the same syntax on whatever flavour UNIX you're running... but you get the idea...

bfn
SB Received on Thu Mar 15 2001 - 18:54:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US