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