Re: two databases

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Wed, 18 Apr 2001 23:18:28 +0200
Message-ID: <3ADE04A4.28C035FB@0800-einwahl.de>

What do you mean by "dropping tables reindex"? What exactly are you doing that makes the instance unavailable?

If you have to rebuild indexes you can do most of it by "alter index ... rebuild online" which will not lock the entire table.

Martin

Patrick Schlaepfer wrote:
>
> We do have a database which gets updated periodicaly. During
> this time the database is unavailable (dropping tables reindex).
> Is there any solution for doing this, together with Oracle 8i and
> OAS 4.
> Was thinking of having two databases, but how does
> OAS knows which database is active.
>
> Regards
> Patrick
Received on Wed Apr 18 2001 - 16:18:28 CDT