Re: dblink

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: Fri, 2 Jun 2000 13:11:43 -0300
Message-Id: <10516.107578@fatcity.com>

Hi

I found database links useful when I had to get subset of data eg. needed smaller database for development. As far as I know there was no option for some sort of WHERE clause in import/export. The dblink worked wery well.

Witold

On 2 Jun 2000, at 5:47, Heidi E. Schmidt wrote:

>
> Folks,
>
> I have been playing around with dblink creation and they are created.
> The questions I have are
>
> When is a dblink useful?
> What benefits does a dblink have over a call at the OS level
> with sqlplus user/passwd_at_aliasname?
>
> Background about my question...
> I have a script a former dba implemented here at my work.
> It checks extents. It is a solid script but he calls a loopback dblink
> on the machine the rdbms resides.
>
> So it gets me wondering if in the init.ora file the global_names=true is a
> security risk and what a loopback link would get him.
>
> The only thing I can think of is to set up one UNIX box with a main work
> tablespace in which all the calls and information is gathered
> (possibly even update meta tables).
> He didn't implement such a thing, but it got me thinking along those lines
> just the same.
>
> Feedback?
>
> Thanks,
>
> Heidi
>
>
> -%---%---%---%----%----%----%----%---%----%---%----%----%----%----%---%---%--
> "What is wanted is not the will to believe, but the will to find out,
> which is the exact opposite."
> -- Bertrand Russell, "Skeptical_Essays", 1928
> -%---%---%---%----%----%----%----%---%----%---%----%----%----%----%---%---%--
>
> --
> Author: Heidi E. Schmidt
> INET: heidi_at_cybercom.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

---

Witold Iwaniec
Senior Software Developer
NovaLIS Technologies Received on Fri Jun 02 2000 - 11:11:43 CDT