Re: [SQL*Loader] redirecting the log file

Hi,
this is the part of my control file:

LOAD
DATA [Quoted] INFILE 'info.dat' BADFILE 'info.bad' DISCARDFILE 'info.dis' LOGFILE '/tmp/info.log'
APPEND
INTO TABLE info FIELDS TERMINATED BY '
' TRAILING NULLCOLS

(                                                                               
[Quoted]   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 - 12:05:57 CEST