Tuesday, September 23, 2008

ora_rowscn does not seem to work ?

SQL> select scn_to_timestamp(max(ORA_ROWSCN)) from TABLE1;

SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))
---------------------------------------------------------------------------
22-SEP-08 01.13.30.000000000 PM

SQL> insert into table1 values(8);

1 row created.

SQL> select scn_to_timestamp(max(ORA_ROWSCN)) from TABLE1;

SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))
---------------------------------------------------------------------------
22-SEP-08 01.13.30.000000000 PM

SQL> alter system switch logfile;

System altered.

SQL> select scn_to_timestamp(max(ORA_ROWSCN)) from TABLE1;

SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))
---------------------------------------------------------------------------
22-SEP-08 01.13.30.000000000 PM

SQL> select sysdate from dual;

SYSDATE
--------------------
23 SEP 2008 17:05:07