How to find SCN for a transaction

[rajbase]

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

[pando]

you have to mine the logs with logminer

[BV1963]

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

[aarroyob]

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

[pando]

check

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

[aarroyob]

Thanks a lot