This discussion is archived
8 Replies Latest reply: Mar 28, 2013 5:27 AM by 951290 RSS

dml happened on a table

951290 Newbie
Currently Being Moderated
hi gurus,

i have a doubt , please clear me,

Is there is any view to find the last dml happened on a a particular table?? i am working in oracle version 10.2.0.4.
i don't want to use any trigger or auditing features.

what is the use of DBA_HIST_ACTIVE_SESS_HISTORY and DBA_HIST_SQLTEXT ?

how can i use effectively ?

Regards
Mahi

Legend

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