Re: question about ora_rowscn

From: Mladen Gogala <>
Date: Sat, 4 Jun 2016 09:03:30 +0000 (UTC)
Message-ID: <>

On Fri, 03 Jun 2016 14:46:27 +0200, geos wrote:

> suppose that a table X is created and its content is never modified
> later: no updates, inserts, deletes, merges, nothing. now, there exists
> some other table Y which is constantly being "bombarded" with DMLs. I
> would like to see the data from table Y as they were at the moment of
> creation of table X. I would like to use this select statement:
> select * from tableY as of SCN <value of scn>;
> is it safe to use as <value of scn> the value:
> select min(ora_rowscn) from table X;
> as SCN representing the moment of table X creation?
> thank you,
> geos

[Quoted] I would say that it is safe to do so. Use for what? What restoring a database copy?

Mladen Gogala
The Oracle Whisperer
Received on Sat Jun 04 2016 - 11:03:30 CEST

Original text of this message