[SQL*Loader] redirecting the log file

Carsten Jacobs

unread,

Apr 13, 2000, 3:00:00 AM4/13/00

to

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

Sybrand Bakker

unread,

Apr 13, 2000, 3:00:00 AM4/13/00

to

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...@tool42.com> schreef in berichtnieuws
38F6033A...@tool42.com...

Carsten Jacobs

unread,

Apr 14, 2000, 3:00:00 AM4/14/00

to Sybrand Bakker

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

I tried to arrange the output files in a different order but got the
same result

Greetings from Berlin

Carsten

Sybrand Bakker schrieb:

Mike Dwyer

unread,

Apr 14, 2000, 3:00:00 AM4/14/00

to

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...@tool42.com> wrote in message
news:38F6ED85...@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 ,

Jonathan Gennick

unread,

Apr 14, 2000, 3:00:00 AM4/14/00

to

Use the LOG command-line option:

sqlldr control=yadda.ctl data=yadda.dat log=/user/home/x

regards,

Jonathan

_____________________________________________________
jona...@gennick.com
http://gennick.com
Brighten the Corner Where You Are