| Database Links [message #20441] |
Thu, 23 May 2002 22:21  |
Frank Chileshe
Messages: 7
Registered: November 2001
|
Junior Member |
|
|
Please help me with the full syntax on
how to create a database link, especially
the clause dealing with the
USING 'dbstring'.
>>create [[public]] database link mylink
USING 'dbstring';
I need to know the syntax for 'dbstring'.
I have two Oracle 8.x databases running
on different machines and want to link the
two using a database link. The network
protocol in use is TC/IP.
I will appreciate your help and were possible
sites that give more detailed information.
Thanking you in advance.
Frank Chileshe (From Zambia)
|
|
|
|
| Re: Database Links [message #20443 is a reply to message #20441] |
Fri, 24 May 2002 05:12  |
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
|
Senior Member |
|
|
sir,
i read your message.no problem .it is quite
easy.
i am giving one example for you.
for example take the first database
(
sid=orcl
database name=oracle
db_domain=uk.com
host string=ss1
)
first edit the parameter file for the following
db_domain=uk.com
then start the database
In the svrmgr30.exe or sqldba execute this command
alter database rename global_name orcl.uk.com;
(name should be sid.db_domain)
then you execute this command
select * from global_name;
then you got the global database name for that
database like
orcl.uk.com
then go to the second database
(sid=tan
databasename=tani
db_domain=usa.com
host string=ss2
)
edit the parameter file for that database
db_domain=usa.com
start the database
execute this command in the svrmgr30 or sqldba
alter database rename global_name tan.usa.com;
(if in this server also the sid is orcl
don't worry.but only thing is
you should have different
db_domain parameter in each database)
execute this query
select * from global_name;
tan.usa.com
go to the first database
then create the database link by following
(execute this command in the first database)
create database link tan.usa.com
conect to system identified by manager
using 'ss2';
note :
the database link name should be the global database
name for the another database
if you have any problem ,please mail to me.
K.SREENIVASAN(INDIA)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
