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

Thread: scn and time change

  1. #1
    Join Date
    Sep 2001
    Posts
    120
    hi,

    what i SCN AND WHAT IS THE SIGNIFICANCE.

    how do i know that SCN VALUES correspond to the WHICH time.

    thanks
    Saurabh Garg
    OCP 9i

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    scn = system change number = oracle internal clock

    you cannot know which scn occured at what time, you can only know between an interval of time by looking checkpoint time

  3. #3
    Join Date
    Sep 2001
    Posts
    120
    hey,

    i want to know the scn for running flashback query.

    in my previous post i have asked but pando says you cant find scn and has said how could i do it.

    i am new to dbaing

    please let me how.

    saurabh
    Saurabh Garg
    OCP 9i

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    SCN stands for both System Change Number and System Commit Number. These are the same thing, but different names for the timing mechanism Oracle uses to guarantee ordering of transactions and to enable correct recovery from failure.

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    You can enable Flashback using SCN or Time:

    EXECUTE Dbms_Flashback.Enable_At_System_Change_Number(123);
    EXECUTE Dbms_Flashback.Enable_At_Time('28-AUG-01 11:00:00');

    If you use time Oracle determins the SCN that best fits the specified time.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

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