Tuesday, February 20, 2007

Determine current SCN in an Oracle Database

A SCN can be useful to determine to which point in time an imcomplete recovery must be execute. Prior to a test or something dangerous, you can query your SCN so you can recovery or flashback to this SCN discarding changes to your database. The current SCN can be queried as follows:

SQL> select current_scn from v$database ;


No comments: