Re: Oracle table snapshot

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Sun, 2 Feb 2003 11:18:14 -0600
Message-ID: <v3qkme8muj3a47@corp.supernews.com>

One thought, you may wish to put a trigger on your table, and have the trigger insert before pictures of the data into a second audit table.
Then you can see what records changed.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"tommy" <tommynospam_at_yahoo.com> wrote in message news:4f0df91b.0302012129.34d529d9_at_posting.google.com...
> New to Oracle and was wondering if Oracle has any kind of built-in
> utility that can take a snapshot of a table or set of tables and
> compare to a second snapshot. I would use this to determine exactly
> what changed in a table once I run a procedure in development. So
> many times I have run in to the situation that I write a procedure to
> change one thing and although it changed it, I didn't know that it
> changed 30 others.
>
> Thanks. Any help would be appreciated.
Received on Sun Feb 02 2003 - 11:18:14 CST