Re: Timestamp of last change to table/partition - how to obtain?

Dave Irick wrote:

> We need to know the timestamp of the last update/insert/delete to a
> table partition (release 9.2.0). The goal is to avoid the resource
> expense of repeatedly exporting huge partitions when their data has
> not changed. Periodic monitoring of "write" statistics in
> v$segment_statistics has produced inconsistent and unexplainable
> results. Auditing does not address partitions. Does anyone know if
> there might be such timestamp info in segment headers, and whether
> Oracle externalizes this info in some way?
>
> TIA,
> Dave

You can't without creating a timestamp column on the table or creating some in-house auditing mechanism.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)