Re: Database management strategy
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 8 Feb 2012 02:18:14 +0000 (UTC)
Message-ID: <pan.2012.02.08.02.18.14_at_gmail.com>
On Tue, 07 Feb 2012 16:59:27 -0800, onedbguru wrote:
Date: Wed, 8 Feb 2012 02:18:14 +0000 (UTC)
Message-ID: <pan.2012.02.08.02.18.14_at_gmail.com>
On Tue, 07 Feb 2012 16:59:27 -0800, onedbguru wrote:
> There are others like Active Data Guard (sort-of like bi-directional
> streams) but better.
Funny thing, I've just finished research of the active DG for the company that I'm working for. The show stopper is the fact that it isn't possible to use global temporary tables on active DG. The idea was to replace streams replicated schema from 10G, but the software utilizing it relies in some cases on populating a GTT before producing a report. Also, you can use GTT on a logical standby (10G) but not on active standby. Logical standby is also supposed to be read-only, but temporary tables can be used. No such luck with an active DG.
-- http://mgogala.byethost5.comReceived on Tue Feb 07 2012 - 20:18:14 CST