How to scale the Oracle

[amerbaig]

I have two machines running on Win2K with Oracle 8.1.7 I want to do such a arrangments that my two databases running on both machines seems one to me. I am most concerned with space. I want to use one of the machine with 200GB free space.

Is it possible to create one table space in which the harddisks of another machine be refered?

Would I need to install Oracle Parallel Server to connect two machines. This way I can loadbalance my long running queries.

Or is there any other solution possible.

Please reply soon

Amer

 

[sem]

You do need Oracle Parallel Server and you also need your w2k to work on cluster.

 

[amerbaig]

Please explain the procedure and process. I will be obliged.

Regards,

Amer

 

[sem]

In fact I do not know whether w2k supports clustering at all. We use Solaris and a set of aditional (both Sun's and third party) software as well as high-speed fibrechannel connection. I also saw it working on Linux. But again, installing OPS is quite straightforward and well documented task, asuming the cluster software is installed and confidured.

 

[amerbaig]

Dis somebody install OPS on Win2K?

Please help

Amer