Hi,
I need to pull out log file for all the SQLs executed from 6th April - 13th April for a specific schema & table.
I tried using DBA_HIST_ACTIVE_SESS_HISTORY / DBA_HIST_SQLTEXT but didn't find any data related to that table.
The reason I require this log is a particular field was updated by some user. Want to check to when did this happen & which user has done it. We know it has happened between 6th & 13th April.
TIA,
Raj
I need to pull out log file for all the SQLs executed from 6th April - 13th April for a specific schema & table.
I tried using DBA_HIST_ACTIVE_SESS_HISTORY / DBA_HIST_SQLTEXT but didn't find any data related to that table.
The reason I require this log is a particular field was updated by some user. Want to check to when did this happen & which user has done it. We know it has happened between 6th & 13th April.
TIA,
Raj