-
view earlier transaction
I have table emp,it contain 200 rows
all the rows are updated many times ,
2 year ago one user modify the third row.
how to get this information? is it possible in oracle 9i?
-
Two years ago?
Logminer is the tool; do you have the logs?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
Two years ago?
Logminer is the tool; do you have the logs?
Thank U
can i use flash back feature in 9i?
-
Originally Posted by sinu009
can i use flash back feature in 9i?
You can, providing you setup flasback feature two years ago and your flashback area holds two years of activity. A long shot, huh?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
You can, providing you setup flasback feature two years ago and your flashback area holds two years of activity. A long shot, huh?
OH sorry ,Thank U very much
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
|