Solved

How to find the last change in a oracle Table

Posted on 2011-09-27
4
337 Views
Last Modified: 2012-08-14
Dear team,

Need one help. I have one oracle table where for few records we have changed a particular field recently.
The field is a boolean field and either t or f can be saved there.
Is there any way we can find what are those records.
We have last sysmodtime but that saves the time of last any type of change in the table.

Appreciate your quick response.
0
Comment
Question by:AnandSahoo
  • 2
  • 2
4 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 36712234
if you have fine grained auditting turned on to capture that sort of activity.

or if you have triggers with your own application logging

but, if you didn't set up something to capture it,  no.

the only way to do it would be through log miner
0
 

Author Comment

by:AnandSahoo
ID: 36712309
No We dont have anything setup to capture.
How can I use teh log miner ?

Please can you give some idea abt it
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 36712372
you'll need to work with your dba to set it up and possibly retrieve old files for you.
  He/she should be able to help you out.

Here's an overview though.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/logminer.htm
0
 

Author Closing Comment

by:AnandSahoo
ID: 36936141
Thank You
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question