DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Getting the last SCN and associated time stamp for oracle 8.1.7.4

  1. #1
    Join Date
    Sep 2005
    Posts
    13

    Getting the last SCN and associated time stamp for oracle 8.1.7.4

    Hi

    Iam using oracle 8.1.7.4.
    What is the SQL statement to find the last SCN and associated time stamp for the last transaction.

    Thanks in advance

    With Regards
    Vara Prasad

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What do you do with the LAST SCN?


    SQL> select dbms_flashback.get_system_change_number
    from dual;

    GET_SYSTEM_CHANGE_NUMBER
    ------------------------
    78305974

    Tamil
    Last edited by tamilselvan; 10-05-2005 at 04:11 PM.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    DBMS_FLASHBACK in 8.1.7 ?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Sorry I did not see the Oracle release.

    Tamil

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