Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database links can no longer be aliased in Oracle 8, what to do?

Re: Database links can no longer be aliased in Oracle 8, what to do?

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 07 Jan 2002 20:14:13 +0000
Message-ID: <3C3A0195.18BDA0AE@exesolutions.com>


If I understand your use of the term "aliasing" you are incorrect. You can give a dblink any name you want. But to do so you must have the init.ora parameter global_names set to False.

global_names = false

Daniel A. Morgan

Oliver Weishaar wrote:

> I have a problem with upgrading from Oracle 7 to Oracle 8. Our code
> has many references to database links, which we aliased so we could
> easily refresh our development and test database from production. In
> Oracle 8, aliasing is apparently no longer allowed, and the database
> links have to have the same name as the database. Does anybody have
> any suggestions to get around this without doing a lot of recoding?
>
> I appreciate any help I can get on this.
>
> Thanks,
> Oliver
Received on Mon Jan 07 2002 - 14:14:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US