dblink

From: Heidi E. Schmidt <heidi_at_cybercom.net>
Date: Fri, 2 Jun 2000 08:36:05 -0400 (EDT)
Message-Id: <10516.107531@fatcity.com>

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

-%---%---%---%----%----%----%----%---%----%---%----%----%----%----%---%---%--
Received on Fri Jun 02 2000 - 07:36:05 CDT