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?

Quote:

---

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?

Quote:

---

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?

Quote:

---

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