Re: Changes made in Oracle Tables
From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Sun, 12 May 2002 11:56:15 +0100
Message-ID: <3CDE4A4F.D31B402_at_exesolutions.com>
Date: Sun, 12 May 2002 11:56:15 +0100
Message-ID: <3CDE4A4F.D31B402_at_exesolutions.com>
WISCO wrote:
> How to determine if an oracle table has been updated?
> I try select * from all_tables but unable find out the time stamp like what
> we have in windows explorer.
>
> Better still if I can know the exact record being changed.
>
> Is there any utility to compare the table before and after any changes?
Right idea ... wrong data dictionary view. Look at the CREATED and LAST_DDL_TIME columns in ALL_OBJECTS.
Daniel Morgan Received on Sun May 12 2002 - 12:56:15 CEST