Re: Can you spread a database across multiple servers?

Thanks-suspected that was the case but didn't know for sure.

Sybrand Bakker wrote:

> Evidently that is going to be a network drive. So there is only one
> answer: No you can't, Oracle won't let you. And the same applies as to
> in the NFS situation: it would be slow and unreliable.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> On Thu, 26 Apr 2001 13:25:55 -0800, Calvin Crumrine
> <Calvin_Crumrine_at_dced.state.ak.us> wrote:
>
> >NFS? Our NT books define that as Network Filing System developed by Sun.
> >Nothing to do with my question as far as I can see.
> >
> >Absolutely not interested in recommendations. Only thing I'm looking for is
> >an answer to my question-If we're running Oracle on one Win2K server can we
> >create a datafile that resides on another Win2K server in the network?
> >
> >Andrei wrote:
> >
> >> datafiles sitting on NFS will result in bad performance, plus NFS is
> >> not reliable.
> >> you can try looking into disk arrays and SAN.
> >>
> >> On Thu, 26 Apr 2001 12:11:52 -0800, Calvin Crumrine
> >> <Calvin_Crumrine_at_dced.state.ak.us> wrote:
> >>
> >> >If we have 2 Win2K servers, one running Oracle & one for our apps, and
> >> >we run out of disk space on our Oracle server, can we create a datafile
> >> >on the other server? Hypothetical question at this point-we're still
> >> >setting up our first Win2K server but our plans are to eventually have
> >> >2. The Oracle server's hard drive bays will be full while the file
> >> >server will have several empty bays. Should we plan on buying an
> >> >expansion chassis for the Oracle server, or can we use the empty bays in
> >> >the other server?
> >> >
> >> >Thanks.
> >> >
> >>
> >> ---------------
> >> In case I forgot to mention:
> >> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> >> ---------------
> >> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> >> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
  Received on Thu Apr 26 2001 - 17:48:47 CDT