This discussion is archived
10 Replies Latest reply: Dec 3, 2012 12:45 AM by 767685 RSS

find out whether a particular table row was updated

767685 Newbie
Currently Being Moderated
Hi Folks,

In our 10.2 prod environment, I want to find out whether 11 rows was updated or not on yesterday between 2pm to 3pm. I know the table anme and have got the rows id's of interest. dont know audit is enabled or not, or its a only solution or there is some SQL to track it. I will appreciate your input(s).
AS SYSDBA> select * from dba_tab_modifications where table_name='NETAD'

TABLE_OWNER                 TABLE_NAME                PARTITION_NAME               SUBPARTITION_NAME                 INSERTS       UPDATES    DELETES TIMESTAMP           TRU DROP_SEGMENTS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ---------- ---------- ------------------- --- -------------
OKISI                      NETAD                                                         1458          5452        0 26-11-2012 22:13:46 NO           0

 AS SYSDBA> show parameter audit

NAME                         TYPE      VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                string      /oracle/admin/db1/adump
audit_sys_operations               boolean      FALSE
audit_syslog_level               string
audit_trail                    string      NONE
Thanks a lot.

Best Regards

Edited by: John-M on Nov 27, 2012 3:52 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points