You need to include a column to capture the last modification time. Oracle
will not store the last modification time by itself.
--
Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX
Rick Stacy <rstacy_at_alphagene.com> wrote in article
<32DEB04B.41C6_at_alphagene.com>...
> Hi,
>
> I need to know when rows within my database have last been modified so
> that I can send updates to remote sites using a variety of RDBMS. Based
> on the documentation I have seen, Oracle 7.3.2 does not keep track of
> this information. I was hoping that it was stored within a pseudocolumn
> such as ROWID or LEVEL (it doesn't hurt to hope, does it? ;-). Is this
> true or am I missing something? Are there any hidden 'tricks' I'm not
> aware of?
>
> Short of adding separate columns to the tables and maintaining the
> information through our application, does anyone have any suggestions
> regarding the best way to handle this requirement?
>
> Thanks in advance,
>
> Rick
>
> --
> Rick Stacy
> Scientific Database Engineer
> AlphaGene, Inc.
> Email:rstacy_at_alphagene.com
>
Received on Fri Jan 17 1997 - 00:00:00 CST
