Re: Oracle architecture question

Possible in theory. Install an Oracle database on the other machine. Create a DB link to the back end data machine that accesses the same tables. Use synonyms to hide the username and @dblink syntax. Re-create your stored procedures in the middle tier - they will access the data they require over the DBlink.

However, while in theory possible, this may not be practical - this may not work for all PL/SQL code or data types, you may see a drop in performance, and it may make maintenance of your procedural code much harder to manage. What is the problem you are trying to solve (and version of Oracle in use) ?

> From: "John Dunn" <JLDunn_at_ukgateway.net>
> Organization: UUNET WorldCom server (post doesn't reflect views of UUNET
> WorldCom
> Newsgroups: comp.databases.oracle.server
> Date: Mon, 22 Jan 2001 19:45:49 -0000
> Subject: Oracle architecture question
>
> Currently our application consists of datbase tables plus stored procedures,
> all of which are held and run on the same machine.
>
> Is it possible to run the stored procedures on another machine and access
> the database which would still be on the current machine?
>
> What Oracle software would I need to install on the second machine?
>
> Where would the stored procedures live? still on the database machine?
>
> N.B. We use dbms_job and utl_file pacakages as well.
>
> John
>
>
>
>
Received on Mon Jan 22 2001 - 21:17:15 CST