On Fri, 1 Oct 2004 13:20:51 -0400, Ruth Gramolini <rgramolini@xxxxxxxxxxxxxxx> wrote: > In 9i you can look at the table smon_scn_time in the sys schema. You can > view the times and scn's associated with them from there. Instead of a > function, it is a table query. Which version of 9i are you finding this in? It isn't on 9.2.0.4 on Linux. Jared -- //www.freelists.org/webpage/oracle-l