Thanks for the question, Bolat.
Asked: October 13, 2016 - 12:15 pm UTC
Last updated: October 13, 2016 - 1:36 pm UTC
Version: 11.2.0.4.
Viewed 1000+ times
You Asked
Hi Tom,
we came across the request from customers.
There were some activities on table (let's name it T1),
audit was not turned on from the creation of db.
Customer raised request to provide some trace or audit for T1-
all activities for past 3 days - 10,11,12 October 2016.
Is there any table or file - where we can check and get it?
With regards!
and Chris said...
If you've not enabled auditing and haven't built any of your own logging then this information is gone!
If you're lucky and your system has a large undo_retention set you
may be able to see the recent changes using a flashback "versions between" query:
select t.*,
versions_xid,
versions_operation,
versions_startscn,
versions_endscn
from t versions between timestamp sysdate - 1/1440 and sysdate
But in all likelihood this information is gone!
For further details see
https://oracle-base.com/articles/10g/flashback-10g#flashback_version_query
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment