Re: updated rows ++ ROWDEPENCIES & ORA_ROWSCN

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1106766021.741530_at_yasure...
> hastenthunder wrote:
>
>> Hello,
>>
>> Is there a easy way for a DBA to get all the rows in a particular table
>> that
>> have been updated since a specified timestamp?
>>
>> Thanks
>
> Where's the timestamp? In the table with the data? If so ... then
> obviously the answer is yes and you know how to do this unless you
> are a student.
>
> If not then the answer is no unless you are in 10g and have enabled
> ROWDEPENDENCIES and kept track of SCN's in relationship to timestamps.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)

tom kyte's flashback query solution gave a nice solution, although it might not be great on performance

creating a table with ROWDEPENDENCIES is quite a nice approach (doesn't look like ALTER TABLE supports changing this), especially when making use of SCN_TO_TIMESTAMP(ORA_ROWSCN) interesting, it appears that ORA_ROWSCN goes NULL for updated rows until they are committed ... i suppose that makes sense, no SCN assigned until a 'system change' is done

the docs still refer to ORA_ROWSCN returning "a more fine-grained approximation of the SCN"

anybody have any thoughts or experience on how reliable ORA_ROW_SCN is when used with ROW_DEPENDENCIES?

++ mcs Received on Wed Jan 26 2005 - 13:34:42 CST