Re: Quiesce on Standard Edtion

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Fri, 13 Jun 2014 21:54:03 +0200
Message-ID: <CALH8A90B-1SQKuT8v6ceLxe4qyn6d3cF4JM-4WncqC03iVm+JA_at_mail.gmail.com>

Have you ever considered Edition Based Redefinition? I'd say it's developed for exactly this purpose. and a .5 min google research shows it might be available in SE as well: https://community.oracle.com/message/9261453#9261453

hth
 Martin

On Mon, Jun 9, 2014 at 8:01 PM, Charlotte Hammond < dmarc-noreply_at_freelists.org> wrote:

> Actually, this might be fairly simple....
>
> Instead of using the view directly we can use a synonym, recreate the view
> with a different name (including the instead-of trigger) and then just
> recreate the synonym to the new version of the view. Seems to work fine
> in a small test case.
>
> Thanks for your time!
> Charlotte
>
>
> On Monday, June 9, 2014 12:43 PM, Charlotte Hammond <
> charlottejanehammond_at_yahoo.com> wrote:
>
>
> Hi All,
>
> Is Quiesce Database not supported on Standard Edition? I get "ORA-00439
> feature not enabled: Database resource manager." Since DRM is used
> behind the scenes and that's an enterprise feature I guess the strong
> implication is no. But I thought I'd just check as I haven't seen Quiesce
> explicitly stated as an Enterprise feature.
>
> What I want to do is recreate a heavily accessed view which has an
> instead-of-trigger on it without downtime. Quiesce sounded like a good
> match but not if I have to spend $$$s on licences to avoid 100ms of
> downtime! Any other alternatives welcome (I can't change the code though -
> otherwise a simple wait-and-retry exception handler might have been an
> option)
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 13 2014 - 21:54:03 CEST