Re: Detecting changes on a table

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 04 Jul 2002 15:59:20 GMT
Message-ID: <3D2470B1.4B3FCA@exesolutions.com>

vivek wrote:

> Is there any way of detecting changes on a table(without using triggers in
> any way).
>
> Thanks

By detecting changes do you mean the SQL that made the change? An itemized list of what was changed? Or just that something was changed?

If the first two you have no choice but a trigger.

If the later, look at LAST_DDL_TIME in user_objects, all_objects, or dba_objects.

Daniel Morgan Received on Thu Jul 04 2002 - 10:59:20 CDT