Re: Newbie: Accessing different databases from isqlplus

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 16 Jan 2007 08:15:20 -0800
Message-ID: <1168964117.996123@bubbleator.drizzle.com>

Jim Andersen wrote:

> sybrandb wrote:

>> If you set up database links
>> (create database link foo using '<tns alias *on the server*>')
>> and you make sure you use identical username and passwords everywhere,
>> you don't need to use
>> connect to identified by
>> in the create database link command.
>>
>> Obviously this is documented on http://tahiti.oracle.com

> 
> This looks very promising.
> Thank you for the tips.
> 
> /jim 

Except it isn't what you want if you mean schema.

The help you are receiving assumes you mean "database" with the Oracle definition which appears to not be the case.

If that is the case learn database links ... but not today.

PS: Add SYNONYMS to the list of subjects to understand in Oracle.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jan 16 2007 - 10:15:20 CST