Yong,
That is the problem. It is not documented. I think that is the reason why
we went down that path of designing our application. I have an email from
oracle rep (RAC team member). He confirmed that with Oracle product
development.
We were running RAC on Tru 64. I was told that it is an
Title: How to create two db-links within one schema when global_names=true?
Hi!
Is there a way to create two db-links within one schema when global_names=true?
e.g.
create public database link DB1 connect to hr identified by pwd_hr using 'DB1';
create public database link DB1
Hi!
Is there a way to create two db-links within one
schema when
global_names=true?
e.g.
create public database link DB1 connect to hr
identified by pwd_hr using
'DB1';
create public database link DB1 (???) connect to
shipping identified by
pwd_shipping using 'DB1';
This is 8.1.7 on Solaris
Title: How to create two db-links within one schema when global_names=true?
You can create as many dblinks as you want provided
that the dblink name is the same as the global name of the database you connect
to.
In your example:
Create public database link HR connect to HR identified
://www.jlcomp.demon.co.uk/faq/ind_faq.html
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 08 January 2003 10:57
global_names=tr
Hi!
Is there a way to create two db-links within one schema when
global_names=true?
e.g.
create public database link DB1 connect to hr
Title: AW: How to create two db-links within one schema when global_names=tr
Hi Jonathan,
thanks for your reply.
The deal is that you can't use DB1@HR and DB1@SHIP if you are using global_names=true; the link name has to be the same than the global database name.
But what do
;
select * from global_name@db1@shipping;
Regards
David Lord
-Original Message-
Sent: 08 January 2003 09:44
To: Multiple recipients of list ORACLE-L
Hi!
Is there a way to create two db-links within one schema when
global_names=true?
e.g.
create public database link DB1 connect to hr
as follows -
select * from global_name@db1@hr;
select * from global_name@db1@shipping;
Regards
David Lord
-Original Message-
Sent: 08 January 2003 09:44
To: Multiple recipients of list ORACLE-L
Hi!
Is there a way to create two db-links within one schema when
global_names=true
Lord
-Original Message-
From: Yechiel Adar [mailto:[EMAIL PROTECTED]]
Sent: 08 January 2003 13:19
To: Multiple recipients of list ORACLE-L
Subject: Re: How to create two db-links within one schema when
global_name
David
The problem is that HR and SHIPPING are the same database
,
thanks for your reply.
The deal is that you can't use DB1@HR and DB1@SHIP if you are using
global_names=true; the link name has to be the same than the global
database
name.
But what do I do, if I need the same user to have two db-links to
different
schemas on the remote database?
Any idea
Anyone have/know of a good way to check performance over dblinks?
Kathy
I don't know about anyone else, but I am looking forward to the long 4th of July
weekend.
Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are
Hello,
Oracle 8.1.6 on Solaris 2.7.
Can any one provide me with information or a link regarding
performance of views across database links?
I am thinking of the case where instance A has a view defined
as SELECT FLD1,FLD2,... FROM TABLE_T1@DBLINK.
Consider the case when a view such as this is
Bill,
I too would love to hear from better experts than me.
I also have implemented queries using db links.
In my rudimentary testing, I found that you need to create the view on the
remote machine to get any decent kind of performance, and then access that
view thru the db link. My guess
kinda sorta in link$ (including the in the clear password)
woohoo.
joe
[EMAIL PROTECTED] 07/31/01 11:48AM
All,Where is the source for database links stored ? Perhaps,
another to state myquestion is:How can I fully reconstruct a database link
?TIAAl
Rusnak804-734-8453[EMAIL PROTECTED]--
George,
The code below will near enough do it (at least way back here in 7.3.4)
assuming the passwords aren't encrypted (I think you can force that in the
init.ora)
-Original Message-
Sent: 31 July 2001 16:48
To: Multiple recipients of list ORACLE-L
All,
Where is the source for
SELECT d.owner, d.db_link, d.username,d.host, d.created, l.password
FROM dba_db_links d, sys.link$ l, dba_users u
WHERE d.db_link = l.name
AND d.owner = u.username
AND l.owner# = u.user_id;
-Original Message-
George A.
Sent: Tuesday, July 31, 2001 11:48 AM
To: Multiple recipients of
This will only give you the public database links. You will also need to
log in as the schema that owns the private database link, if that's the
case, and look at user_db_links.
--Michael
-Original Message-
Sent: Tuesday, July 31, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
Another script:
set linesize 120
column db_link format a20
column username format a15
column host format a20
column owner format a20
select * from global_name;
select * from dba_db_links;
clear columns
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Good point. I have tested the following to capture both PUBLIC and private
db links.
set linesize 500;
set pagesize 1000;
column owner format a20;
column link_name format a20;
column userid format a20;
column host format a20;
column password format a20;
SELECT u.name owner, l.name link_name
Alex,
Yes, the connection remains open unless it is
explicitly closed (see Note: 1034343.6).
The session also takes out a lock on the local RBS
(see Note:74811.1) as this could be part of a
distributed transaction. If this is a long running
query this can lead to abnormal growth in the RBS
If I query table in the remote database using database link does user in the
remote database which is referenced in the database link create session in
the remote database and if not could somebody explain how remote query is
executed.
Alex Hillman
P.S. I know that I could try it myself but I
Yes, it creates a session. If you want to do a(n) SQL trace, you can do a
SELECT 'x' FROM dual@remote_site, find the session at the remote site and
turn on the trace, then run your next query.
Henry
-Original Message-
Sent: Monday, July 09, 2001 5:06 PM
To: Multiple recipients of list
Hillman, Alex wrote:
If I query table in the remote database using database link does user in the
remote database which is referenced in the database link create session in
the remote database and if not could somebody explain how remote query is
executed.
Alex Hillman
P.S. I know
Sharma To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
ssharma1@fcsl cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
td.com Subject: db links
make the connect string of the remote database in the
local machine in the tnsnames.ora using net 8 easy
configuration tool.
--- Saurabh Sharma [EMAIL PROTECTED] wrote: hi
all,
can any body has idea of how to create db links. we
have 4-5 servers some are test and some producn.
while
to public.
--- Saurabh Sharma [EMAIL PROTECTED] a écrit :
hi all,
can any body has idea of how to create db links. we
have 4-5 servers some are test and some producn.
while requiring some info from other DBs how do i
refer them ythrough DBlinks.
Saurabh Sharma
[EMAIL PROTECTED]
http
Saurabh
Sharma To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
ssharma1@fcsl cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
td.com Subject: db links
Has anyone been successful in using their standby database operating in
read-only mode through a dblink? I can't find any admonishment in the docs.
The dev guys says it will be find for the front-end java code to fail on
any updates.
Ritchie Lau
[EMAIL PROTECTED]
)
Sent: Tuesday, April 10, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Subject:db domain being appended to db links when global_names
= false
What am I missing?
When I create a database link
I've had similar problems with the global_names issue with respect to creating a
database link. In my case, I tried to create a link from my development machine
(Personal Oracle 8) to a new DB server (8.1.5 on NT). I could not get it to work
until I set global_names = false, but at least when
Hello,
We seem to have more and more questions regarding query
performance across DB Links, and how to improve it.
I have the Gurry/Corrigan book, but can't find anything on
this specific topic.
Can anyone point me to a good whitepaper or other article
regarding query performance across DB Links
Bill,
Also, you don't want to join remote tables together. Create a join-view on
the remote database instead.
Kevin
-Original Message-
Sent: Thursday, February 01, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L
Bill,
Queries across DB links are pretty messy. Check
32 matches
Mail list logo