Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sqlloader log file

RE: sqlloader log file

From: Mecci, Shaheer (MBS) <Shaheer.Mecci_at_mortgagefamily.com>
Date: Tue, 2 May 2000 16:28:26 -0400
Message-Id: <10485.104738@fatcity.com>


Susan
Try the silent mode in the SQL*Loader command-line or ctl file.  

  silent -- Suppress messages during run (header,feedback,errors,discards,partitions) Ex: SILENT=errors  

HTH
Shaheer Mecci.
-----Original Message-----
From: Susan Schuster [mailto:sschuster_at_nearme.com] Sent: Tuesday, May 02, 2000 4:07 PM
To: LAZYDBA
Subject: sqlloader log file

Is there any way to have sqlloader not produce a log file? I am processing large files that have a very small number of rows that I want to load and I wanted to use the WHEN clause to only load those rows. Unfortunately, an entry is written to the log file every time a row fails the WHEN clause.    

Thanks for the help! Received on Tue May 02 2000 - 15:28:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US