Re: Distrubuted DB's??

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 Mon Aug 26 1996 - 00:00:00 CEST