Title: Database Links standards
Jeff,
Looks
ok, except that I don't think you need step b) - the PUBLIC SYNONYM for the
remote table.
I
always create a private synonym within my DBA account (which happens to own the
tables in the local database) and then create the VIEW and a PUBLIC
Title: Database Links standards
this
is fine.
your
problem may be in marketing the technology, not the technology itself.
-Original Message-From: Thomas Jeff
[mailto:[EMAIL PROTECTED]]Sent: Friday, July 06, 2001 4:51
PMTo: Multiple recipients of list ORACLE-LSubject:
Looks good to me, except for step b.
You don't really need that.
I've used the same setup several
times successfully.
Jared
On Friday 06 July 2001 13:51, Thomas Jeff wrote:
We came up with the below standards with respect to database links
(heavily
used in our environment). The
Can I give a suggestion ,
how about create a unique user which will have all the link db , so much so
that we will know where is the link come from , and it seen easily to manage
? Will it be a solution to this ?
-Original Message-
Sent: Thursday, May 31, 2001 2:46 PM
To: Multiple
Tracy,
I have a similar deal going on here. If you are on version 8.1.x and the
lookup tables are large, you can use Materialized Views, and since they are
lookup tables that shouldn't change much, you should only have to refresh
them every once in a while. If they are really small tables,
We have several large look-up tables that we
use in development as well as in production
environments. The data is the same
Developers shouldn't work against production tables.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Tracy,
Allowing developers to muck around in your production system is not
generally a good idea. If you create db links for them, that's what they
will be doing.
In addition, have you ever managed an environment like that? I have and
it's not pretty.
How will you administer the privileges?
Hi, Millie,
Try this location
ftp://oracle-ftp.oracle.com/server/
HTH
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Wednesday, April 11, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
I have set the global_names parameter to false on my mainframe database ORS1
and
01 9:00 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: database links
Millie,
Check both instances and verify if global_names parameter is switched on.
What is the name of your db link?
select * from global_name;
Is it the same as global_name?
I have a problems creating data
hi millie,
you must verify that the host name is resolved in the unix platform(DNS),
otherwise put the physical adress in the description of the host.
Best Regards,
Nabila Mekkaoui
DBA
-Message d'origine-
De : Chan, Millie [mailto:[EMAIL PROTECTED]]
Envoy : vendredi 6 avril 2001
Millie,
Check both instances and verify if global_names parameter is switched on.
What is the name of your db link?
select * from global_name;
Is it the same as global_name?
I have a problems creating database links when I have global_names parameter
set to TRUE.
I normally switch
11 matches
Mail list logo