SCN why is it different
- From: BN <bnsarma@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Jan 2010 19:26:58 -0500
Greetings
Orlace 10.2.0.4, SUN 9
Why is SCN different, shouldn't all of them be same, what am I missing
here
19:19:20 TESTDB:SYS> select current_scn, current_timestamp,
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER() from v$database;
CURRENT_SCN CURRENT_TIMESTAMP
--------------------
---------------------------------------------------------------------------
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER()
-----------------------------------------
10789444571800 18-JAN-10 07.20.38.044102 PM -05:00
10789444571818
1 row selected.
Elapsed: 00:00:00.10
19:20:38 TESTDB:SYS> select timestamp_to_scn('18-JAN-10 07.20.38.044102 PM')
from dual;
TIMESTAMP_TO_SCN('18-JAN-1007.20.38.044102PM')
----------------------------------------------
10789444571785
--
Regards & Thanks
BN
Other related posts:
