RE: VLDBs - Books , References , Links ?

>
> You CAN'T partition tables in 7.3.4 It is a feature introduced in
> Oracle8.0
>

But on the other hand you can partition tables with a partitioned view :-)

> OPS has nothing to do with partitioned tables.
>

Probably confusing the suggestion that partitions and parallel are a good idea.

> I don't know if you can implement OPS on a a single machine,
> but why would
> you want to? OPS is generally used for failover in case of
> server failure or
> to spread the load on the system. Neither of those cases
> would be served by
> implementing it on a single machine.
>

OPS on 1 machine, the ming boggles! I doubt if it's possible due to the IPC/heartbeat thing. Although it used to be possible to put parallel query on one machine.

> No clustering is needed for OPS... but you need to use raw
> partitions, not file systems
>

Which are a bugger to backup on NT for example.

> I would suggest you go back to the docs and do some reading
> there on OPS before you start looking for other reference materials.
Received on Thu May 25 2000 - 08:10:25 CDT