Re: Database mirroring
Date: Tue, 18 Mar 2008 04:43:01 -0700 (PDT)
On 17 Mar, 21:19, "astalavista" <nob..._at_nowhere.com> wrote:
> I have a DW which is loaded every night
> The load process is very heavy so the database is not
> ready in the morning.
> How can I have a other database to open to the users in the morning
> until the loading is finished and then switch with updated database ?
> Somthing like a day-1 database....
> Standby database is a way to go ?
> Thanks in advance
As Netcomrade suggested: tune your loading. How much data are you loading? How is your system configured? What O/S and Oracle versions?
HTH -g Received on Tue Mar 18 2008 - 06:43:01 CDT