OraFAQ Forum: Server Utilities » cut loader logfile

Home » RDBMS Server » Server Utilities » cut loader logfile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cut loader logfile [message #135772]

Fri, 02 September 2005 08:43

magnetic
Messages: 324
Registered: January 2003

Senior Member

Is there a way to manipulate the loader logfile
so it just logs the amounts of loaded and not loaded due to some reason...just want the amounts at the bottom of the logfile
I am not interested in huge logfiles wich contains the rejected due to failing the WHEN clause neither the table decription in the log file...

anyone has a workaround??

thanks in advance.

Report message to a moderator

Re: cut loader logfile [message #135777 is a reply to message #135772]

Fri, 02 September 2005 09:01

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Did you explore SILENT option?
It may help a little, but not much.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch04.htm#1004894

Quote:

# ERRORS - Suppresses the data error messages in the log file that occur when a record generates an Oracle error that causes it to be written to the bad file. A count of rejected records still appears.
# DISCARDS - Suppresses the messages in the log file for each record written to the discard file.
# PARTITIONS - Disables writing the per-partition statistics to the log file during a direct load of a partitioned table

Report message to a moderator

Re: cut loader logfile [message #136037 is a reply to message #135777]

Mon, 05 September 2005 09:12

magnetic
Messages: 324
Registered: January 2003

Senior Member

yea i tried the silent option
still cant get rid of the table description Smile

it helps alot tho..

thanks for your reply..

Report message to a moderator

Previous Topic:	Passing parameters from windows command line
Next Topic:	... Proccesing Exel File. Loading Data.....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 06:11:35 CDT 2024