RE: sqlldr
- From: Noor Mulla <Noor.Mulla@xxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>, "oracle-l-admins@xxxxxxxxxxxxx" <oracle-l-admins@xxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Dec 2009 13:23:35 +0530
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
-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
Sent: Monday, December 14, 2009 1:16 PM
To: Noor Mulla; oracle-l-admins@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: sqlldr
Do you have a question, or are you describing your situation?
On 12/14/09, Noor Mulla <Noor.Mulla@xxxxxx> wrote:
> Hi,
>
> We have SQLLDR SHELL programs that are generated in which there is a line
> for each sqlldr load job.
> We need to monitor or check the results of each load job when it finishes to
> see if there were any load errors.
> This can be either incorporated into the generated sqlldr SHELL program such
> that one line would be added after each sqlldr invocation.
> This line could check the log file for any errors and send email to our
> group showing error(s) if any exist.
>
>
> 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:
