Originally posted by fraze
yep, you're right, thats the current scn#
Are you sure?

Code:
SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
           2078477

SQL> create table t (n number);

Table created.

SQL> insert into t values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
           2078477

SQL>
To JMac

Code:
SQL> select dbms_flashback.get_system_change_number from dual;

GET_SYSTEM_CHANGE_NUMBER
------------------------
                 2079493

SQL>