How to find SCN for a transaction
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How to find SCN for a transaction

  1. #1
    Join Date
    Nov 2001
    Posts
    2

    Question

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to mine the logs with logminer

  3. #3
    Join Date
    Nov 2001
    Posts
    335
    If you know exact time when you dropped a table , you do not need to know SCN and recover up to that time.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

  6. #6
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Thanks a lot


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width