How to find SCN for a transaction

i need some help:
my Oracle dbase is in archive log mode;
i created one table;
then i entered some values;
and then i dropped that table;
How can i recover that table and its data;
How do i find the SCN for that transaction;
Help will be appreciated.
RAJ

you have to mine the logs with logminer

If you know exact time when you dropped a table , you do not need to know SCN and recover up to that time.

Quote:

---

Originally posted by pando
you have to mine the logs with logminer

---

Hi Pando,

Could you explain whati is logminer and how use it?

Thanks in advance and best regards

Angel

check

http://www.dbasupport.com/forums/sho...threadid=17004

Thanks a lot