Re: Database comparisons
From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 11 Jan 2010 13:48:23 -0800
Message-ID: <bf46381001111348s5bd57c55ifae83387fea7477d_at_mail.gmail.com>
On Mon, Jan 11, 2010 at 12:48 PM, Dennis Williams < oracledba.williams_at_gmail.com> wrote:
Date: Mon, 11 Jan 2010 13:48:23 -0800
Message-ID: <bf46381001111348s5bd57c55ifae83387fea7477d_at_mail.gmail.com>
On Mon, Jan 11, 2010 at 12:48 PM, Dennis Williams < oracledba.williams_at_gmail.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 11 2010 - 15:48:23 CST