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: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Tue, 08 Jan 2002 02:07:49 GMT
Message-ID: <3C3A540D.872985F7@shaw.ca>


Ban Spam wrote:
>
> oweishaar_at_phelpsdodge.com (Oliver Weishaar) wrote in
> news:3fac8d9.0201071610.11f1919e_at_posting.google.com:
>
> > 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
> >
>
> Forgive me, I'm unaware of an "ALIAS" command in SQL.
> So, WTF, are you talking about?
>
> If you provide SPECIFIC examples and EXACT error messages,
> you might get some helpful suggestions.
>
> HTH YMVV!
> HAND!
I believe he was referring to synonyms. Received on Mon Jan 07 2002 - 20:07:49 CST

Original text of this message

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