Re: cross-db queries (was Are we losing momentum?)

>
> On Wednesday 16 April 2003 19:40, Rob Butler wrote:
> > a) create remoteview ... (all necessary information about remote machine
> > and query) b) create view [local | remote] .... (necessary info)
> > c) create view remote-server.schema.table (necessary info)
>
> That is not a good way. Oracle does/recommends a create synonym so that either
> a remote view or table can be treated as if it is a loacl table/view. This
> takes care of select/insert/update/delete etc. I think that is a better way
> of integrating remote objects in current database.
>
It may not be the "best" solution, but it is one that is possible to use now (if you don't want atomic remote updates) or could be done with atomic remote updates relatively soon.

It is similar to the way MS-SQL works. And, once setup the local and remote tables all look the same to the client application. I think that is important.

Later
Rob