Re: Find the time stamp of the updates made to the database

On Thu, 15 Dec 2005 08:50:58 -0800, masood.lanker wrote:

> Dear Group,
> I am using oracle 8.1.17, on Solaris 8
> There has been some update in database tables. The table does not keep
> a record of the timestamp, can we check somewhere in O.S. or oracle
> logs or database when the update was made and the exact SQL query that
> had been run

Log miner can help you there. In the future, you should enable auditing. As a minimum, every transaction table you have should contain the following information:

1) Time stamp
2) User who did it.
3) Action done (delete/update/insert).

-- 
http://www.mgogala.com