Re: Using two servers simultaneously

hi sameer,

to connect with other database from within u currently logged in you have to create database link..
before creating link u must grant priviliges for create database link. there are two kind of links
1 Local
2 Public
here is a example:
CREATE DATABASE LINK local(*this is a link type)

   CONNECT TO emp(*this is a database name IDENTIFIED BY scott(*this is a user)

   USING 'tiger'(*and finally this is password); and u can use link as
select * from employee_at_local;(*first table name followed by @ and link name);

Before create links don't forget to grant priviliges to a user, by which u r logged into your database

....
Kerul(DBA) Received on Fri Apr 01 2005 - 22:53:16 CST