Question

怎样查看一个历史时间对应的scn号

Answer 1

>=10g

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
3814379

SQL> select scn_to_timestamp(3814379) from dual;

SCN_TO_TIMESTAMP(3814379)
---------------------------------------------------------------------------
13-JAN-12 04.05.57.000000000 PM

SQL> select timestamp_to_scn(to_timestamp('13-JAN-12 04.05.57','dd-mm-yy hh24.mi.ss')) from dual;

TIMESTAMP_TO_SCN(TO_TIMESTAMP('13-JAN-1204.05.57','DD-MM-YYHH24.MI.SS'))
------------------------------------------------------------------------
3782419