Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: updated rows

Re: updated rows

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 26 Jan 2005 11:02:56 -0800
Message-ID: <1106766021.741530@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)
Received on Wed Jan 26 2005 - 13:02:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US