Re: [SQL*Loader] redirecting the log file

I do not see the keyword LOGFILE in the SQL*Loader documentation. I believe it is a command-line option: log='/tmp/info.log'

"Carsten Jacobs" <carsten.jacobs_at_tool42.com> wrote in message news:38F6ED85.DA3C342F_at_tool42.com...
>
> Hi,
> this is the part of my control file:
>
> LOAD
> DATA
> INFILE 'info.dat' BADFILE 'info.bad' DISCARDFILE 'info.dis' LOGFILE
> '/tmp/info.log'
> APPEND
> INTO TABLE info
> FIELDS TERMINATED BY '
> '
> TRAILING NULLCOLS
>

> ID INTEGER EXTERNAL ,
>
>
> and this is the error message I've got:
> SQL*Loader-350: Syntax error at line 2.
> Expecting keyword INTO or end of file, found "LOGFILE".
> info.bad' DISCARDFILE 'info.dis' LOGFILE '/tmp/info.log'
> APPE
> ^
>
> SQL*Loader: Release 8.1.5.0.2 - Production on Fri Apr 14 11:51:40 2000
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> I tried to arrange the output files in a different order but got the
> same result
>
> Greetings from Berlin
>
> Carsten
>
> Sybrand Bakker schrieb:
> >
> > No reason why this shouldn't work. As you don't post the error we can't
> > resolve it. Anything with protection, diskquota and the like?
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > Carsten Jacobs <carsten.jacobs_at_tool42.com> schreef in berichtnieuws
> > 38F6033A.F6A91ABC_at_tool42.com...
> > >
> > > Hello dbas
> > >
> > > does anybody know how one can redirect the log file which is created
by
> > > SQL*loader?
> > > By default it is in the current directory but I want it in a directory
I
> > > choose.
> > > I tried something like LOGFILE '/home/cratsen/mylogs/tablename.log'
but
> > > got only an error.
> > > Many thanks for any help!
> > >
> > > Carsten
Received on Fri Apr 14 2000 - 17:37:02 CEST