Rob Cowell wrote:
> DA Morgan wrote:
>> Sybrand Bakker wrote:
>>> On Mon, 12 Jun 2006 12:14:02 -0700, DA Morgan <damorgan_at_psoug.org>
>>> wrote:
>>>
>>>> Try this:
>>>>
>>>> select name, value from v$parameter
>>>> where name like '%domain%';
>>>>
>>>> On the remote server.
>>>
>>> Daniel,
>>> In my experience the db_domain parameter is used to determine the
>>> global database name at creation time, and subsequent changes are
>>> ignored, if you don't issue alter database rename global_name to etc.
>>>
>>> The op needs to have the global_name(s?) view at the remote server.
>>>
>>> --
>>> Sybrand Bakker, Senior Oracle DBA
>> Agreed.
>> --
>> 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
>
>
> I probably didn't explain myself very well. db_domain is not set on the
> remote server, and because that db is not controlled by my company we
> can't get one set up easily. I was looking for a way to connect to that
> database via a dblink while I have global_names=true on my db.
And the default domain is?
--
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 Jun 13 2006 - 11:23:53 CDT
