Re: How to view other schemas in TOAD's Schema Browser
by Ubiquitous <weberm@[EMAIL PROTECTED]
>
Mar 28, 2008 at 12:57 PM
In article <47eb9ff0$0$14359$e4fe514c@[EMAIL PROTECTED]
>, whatsin@[EMAIL PROTECTED]
wrote:
>"Ubiquitous" <weberm@[EMAIL PROTECTED]
> schreef:
>> Production instance PROD is linked to another, PROD2, via a datalink.
If I
>> wish to view data in PROD2 I currently have to do it the hard way and
use
>> the SQL Editor window. Is there a way one can view tables in PROD2
using
>> the
>> TOAD's Schema Browser while logged in as PROD?
>>
>> I hope that makes sense...
>
>Maybe by creating synonyms for the "linked" tables.
I have synonyms for the datalinked objects for my queries. Neither that
nor
the instance appears in the drop-down on the Schema Browser.