Re: when table was last changed?
Date: 1995/12/28
Message-ID: <4bt5eo$icf_at_ixnews6.ix.netcom.com>#1/1
In <4bs00k$di8_at_cloner3.netcom.com> chuckh_at_ix.netcom.com (Chuck
Hamilton) writes:
>
>glc <glc_at_neonramp.com> wrote:
>
>>I create a LAST_CHANGE_DATE column in the table and and a trigger to
plug SYSDATE
>>into it on insert, update or delete.
>
>Rather than adding a column to the table, why not just create a 2nd
>table with only two columns - table_name, and update_date? It'd be a
>lot faster to query the date when you need it.
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
>
>If at first you don't succeed, sky-diving isn't for you.
>
SQL*Trax from BMC Software can read the archive logs and determine the
the last update operation either by time or SCN. The table itself is
never accessed during the report operation, Oracle does not even have
to be up. SQL*Trax can print most everything in the redo logs,
including undo SQL.
Received on Thu Dec 28 1995 - 00:00:00 CET