How to Get Current SCN for Oracle 10g 11g Database? DBMS_FLASHBACK.GET_SYSTEM_CHANGE

advertisements

_____________________________________________________________________________________________________________________

There are two ways to get the current scn (System Change Number) for an oracle database.

Method 1

Select current_scn from v$database;

e.g. SQL> select CURRENT_SCN from v$database;

CURRENT_SCN

-----------------

11626841778008

Method 2

Using DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER function

SQL> select DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER from dual;

GET_SYSTEM_CHANGE_NUMBER

------------------------

11626841778005

_____________________________________________________________________________________________________________________

A visitor from Columbus viewed 'Use of Expdp Impdp nologfile=y' 3 hrs 2 mins ago

A visitor from Sariyer viewed 'Fix ORA-01927: cannot REVOKE privileges you did no' 3 hrs 58 mins ago

A visitor from Warsaw viewed 'RMAN Restore Failed RMAN-06100: no channel to rest' 4 hrs 28 mins ago

A visitor from Sariyer viewed 'Fix ORA-01927: cannot REVOKE privileges you did no' 5 hrs 17 mins ago

Archive