Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Find the time stamp of the updates made to the database

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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 15 Dec 2005 20:11:21 +0100
Message-ID: <atf3q1h3v4id6aduqpn1gdfiadqhi66v36@4ax.com> 





On 15 Dec 2005 08:50:58 -0800, masood.lanker_at_gmail.com 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




Sure, identify the exact archive logs, and use dbms_logmnr to inspect
them.


See Thomas Kyte Expert Oracle one on one, Appendix A.


--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Dec 15 2005 - 13:11:21 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US