Home » SQL & PL/SQL » SQL & PL/SQL » rows missing for a date
rows missing for a date [message #315348] Mon, 21 April 2008 04:37 Go to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
Iam using web application application with oracle 10g.Daily data will be sent to this application online, one exe will be uploading the data sent automatically . so on one particular date rows are missing .How can i trace the problem. Help me
Re: rows missing for a date [message #315349 is a reply to message #315348] Mon, 21 April 2008 04:42 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
The information you have supplied is bereft of anything useful that would allow us to even guess as to what you need. Have another look at the posting guidelines and try posting a clearer question.
Re: rows missing for a date [message #315353 is a reply to message #315349] Mon, 21 April 2008 04:55 Go to previous messageGo to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
In my application one table will updated daily by the data sent.the latest date data rows are empty but the data has sent to the application and as usual by the automated exe it will upload.

what i want is is there any provision to know the log files for which updations has done on this date to the table.
Re: rows missing for a date [message #315355 is a reply to message #315353] Mon, 21 April 2008 04:59 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Quote:
the latest date data rows are empty but the data has sent to the application and as usual by the automated exe it will upload
I don't know what this means.
Quote:
hat i want is is there any provision to know the log files for which updations has done on this date to the table.
Well since you give no information about what kind of exe you are using nor what kind of logging it does, nor any other remotely useful information I'm going to once again have to ask you to ask the question again. Remember, we know nothing about your system, your data, your processes etc.
Re: rows missing for a date [message #315394 is a reply to message #315353] Mon, 21 April 2008 07:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, you might create a (daily) job which would check whether there are any records that belong to "today" (or perhaps "yesterday", or any other date) and send you an e-mail if there are no records for this date.
Re: rows missing for a date [message #315402 is a reply to message #315348] Mon, 21 April 2008 07:13 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Check out the MISSING_ENTRIES.log file

[Updated on: Mon, 21 April 2008 07:13] by Moderator

Report message to a moderator

Previous Topic: how to find missing numbers
Next Topic: Need help in copying CLOB data over DBlink
Goto Forum:
  


Current Time: Sat Dec 10 18:48:33 CST 2016

Total time taken to generate the page: 0.13731 seconds