RE: sqlldr

  • From: Noor Mulla <Noor.Mulla@xxxxxx>
  • To: ~Jeff~ <jifjif@xxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Dec 2009 15:04:05 +0530

Jeff,

Basically it should check the log file for any errors and send email to our 
group showing error(s) if any exist.

Thanks & Regards
Noor M


From: ~Jeff~ [mailto:jifjif@xxxxxxxxx]
Sent: Monday, December 14, 2009 1:52 PM
To: Noor Mulla; Oracle-L@xxxxxxxxxxxxx
Subject: Re: sqlldr

depending on the shell etc, it'd be something like:

[ -f somefile.bad ] && mailx -s 'some subject' 
recipient@xxxxxxxxxxxxxx<mailto:recipient@xxxxxxxxxxxxxx> < somefile.log

hope that helps...
Jeff


2009/12/14 Noor Mulla <Noor.Mulla@xxxxxx<mailto:Noor.Mulla@xxxxxx>>

Below(trailing mail) was the question?



We want to make changes to the programs responsible for creating the oracle 
load script and control files

Incorporating monitoring of our SQLLDR jobs into our migration 
programs(checking load errors)



Example:

sqlldr DATACITI_MDE/today05@GERD_UAT_NJ7 
control=Oracle/dbo_DATACITI_MDE.trans_acknowledgeme

nt.ctl direct=true columnarrayrows=10000 readsize=104857600 
log=log/dbo_DATACITI_MDE.trans_ac

knowledgement.log bad=log/dbo_DATACITI_MDE.trans_acknowledgement.bad 
discard=log/dbo_DATACITI

_MDE.trans_acknowledgement.dis



After [adding a line after each sqlldr invocation]

sqlldr DATACITI_MDE/today05@GERD_UAT_NJ7 
control=Oracle/dbo_DATACITI_MDE.trans_acknowledgeme

nt.ctl direct=true columnarrayrows=10000 readsize=104857600 
log=log/dbo_DATACITI_MDE.trans_ac

knowledgement.log bad=log/dbo_DATACITI_MDE.trans_acknowledgement.bad 
discard=log/dbo_DATACITI

_MDE.trans_acknowledgement.dis

#check for existence of bad file. if it exists, send email with log file 
attached



Thanks & Regards

Noor



DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended 
for the named recipient(s) only. 
It shall not attach any liability on the originator or HCL or its affiliates. 
Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the 
opinions of HCL or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is 
strictly prohibited. If you have 
received this email in error please delete it and notify the sender 
immediately. Before opening any mail and 
attachments please check them for viruses and defect.

-----------------------------------------------------------------------------------------------------------------------

Other related posts: