Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: "Steve Ashmore" Newsgroups: comp.databases.oracle.server Subject: Re: Oracle table snapshot Date: Sun, 2 Feb 2003 11:18:14 -0600 Organization: Posted via Supernews, http://www.supernews.com Message-ID: References: <4f0df91b.0302012129.34d529d9@posting.google.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Complaints-To: abuse@supernews.com Lines: 23 Xref: newsfeed1.easynews.com comp.databases.oracle.server:174511 X-Received-Date: Sun, 02 Feb 2003 10:17:33 MST (news.easynews.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" wrote in message news:4f0df91b.0302012129.34d529d9@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.