-
Logminer digging through archivelogs?
Hi All,
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|