Re: Distrubuted DB's??

Allan,

Thank you for the reply. I THINK that's the same thing;-) Look at it this way, I want to have one REALLY big database. I have 6 systems, 2 intel based, and 4 Power PC. I want to use the processing power of all the cpu's in these systems to access the database. I also want the data distributed across each system's storage (each has its own RAID array), so they are all acting as one big system.

Don't get hung up on the Power PC thing, those 4 systems could be Intel based if need be.

See what I mean?

Jim

In article <322200DB.CEF_at_acsatlanta.com>, Allan Hicks <ahicks_at_acsatlanta.com> wrote:
>Jim Ryan wrote:
>>
>> Does Oracle support DB's distributed across multiple CPU's?
>>
>> Jim
>
>Jim,
>
> Yes, chapter 21 of the Server Concepts Manual covers distributed
>databases.
>
> If you don't have the Manual, it describes how to set up views across
>different
>databases on different machines. Oracle gives you the ability to set up
>links
>so that a remote table will obey the same rules as a local table.
>
> I set up four HP-9000 systems, a Novell file server and a diskless PC
>running
>windows 3.11. After fighting with the SQL*Net for a couple of days,
>everything
>worked well. Any of the 9000 could access Oracle tables on any other
>9000 and
>the Novell server. The diskless PC could access any table anywhere as
>well.
>All you had to do was to put an _at_node name on the connect, or set up a
>synonym
>in the database for the remote tables. It was really slick.
>
> I hope that this helps.
>
>-allan
Received on Tue Aug 27 1996 - 00:00:00 CEST