Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    4

    Unhappy Unanswered: SQL Loader with LOGFILE parameter

    Hi all,
    I am having trouble with using the LOGFILE parameter. When I run the following command (shown below), I get an error as follows:
    ---snip---
    LRM-00101: unknown parameter name 'LOGFILE'
    SQL*Loader: Release 8.1.7.2.0 - Production on Thu May 8 16:39:26 2003
    (c) Copyright 2000 Oracle Corporation.__All rights reserved.
    SQL*Loader-100: Syntax error on command-line
    ---snip---
    command:
    sqlldr USERID=n_dba/n_dba@nrd CONTROL=N_DBA.tab_name.ctl LOGFILE=mylog

    What could be wrong ?

  2. #2
    Join Date
    Oct 2002
    Location
    Plymouth UK
    Posts
    116
    Change 'LOGFILE=' to 'LOG=' and it should work fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •