How do i know or find which archivelogs is needed for, to capture the changes being made by user(past in time) so as to dig through logminer,do i have to dig through all archivelogs? its 10g.Please any suggestions would be appericated.
Thanks in advance.
well if you know when the change was done you can work out which log it may be in
Suppose the cjanhge has been made couple of days back ,then what query should i use for it?
select * from v$log_history ;
will show you the time stamp of each redo log started.