On Mon, Jan 11, 2010 at 12:48 PM, Dennis Williams < oracledba.williams@xxxxxxxxx> wrote: > > Triggers on each of 200 tables? Euew. Right now I'm liking Niall's audit > suggestion or Robert's flashback version query as maybe being less > cumbersome. > Not that big a deal, easily generated. BTW, I meant DDL triggers, but either/both may be appropriate. Flashback query it great, just don't forget it ages out. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com