From: gogala.mladen@gmail.com   
      
   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 ;   
   >   
   > is it safe to use as  the value:   
   >   
   > select min(ora_rowscn) from table X;   
   >   
   > as SCN representing the moment of table X creation?   
   >   
   > thank you,   
   > geos   
      
   I would say that it is safe to do so. Use for what? What restoring a   
   database copy?   
      
      
      
   --   
   Mladen Gogala   
   The Oracle Whisperer   
   http://mgogala.byethost5.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)