Re: sqlloader

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