Re: Getting sysdate across a DB link

John Russell wrote:

> On Sun, 09 Mar 2003 10:48:11 -0800, DA Morgan
> <damorgan_at_exesolutions.com> wrote:
> >If you haven't done this before, and I'm sure you have:
> >
> >SELECT * FROM dual;
> >
> >What you suggest is not different from saying:
> >
> >SELECT 'ABC' FROM dual_at_other_server.
>
> I use database links for reporting (bringing in data from multiple
> sources, and doing UNION, INTERSECT, or MINUS on it). Just recently
> started using them for some interactive queries, but then I switched
> from db links to granting permissions and using fully qualified names
> for procedures (since this was running in different schemas in the
> same instance). That technique seems to involve less overhead.
>
> I'm curious what other scenarios people are using database links for,
> and how. (E.g. selecting from table_at_other_server vs. calling
> procedure_at_other_server.)
>
> John

When the data is on another machine; often in another data center.

The ideal scenario, when money doesn't force compromises, is one machine, one database, one application. So an application handling inventory looks to a different machine for customer information.

Daniel Morgan Received on Sun Mar 09 2003 - 21:04:45 CST