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

From: Ban Spam <ban-spam_at_operamail.com>
Date: Tue, 08 Jan 2002 01:46:50 GMT
Message-ID: <Xns918FB4DEECBBSunnySD@24.0.3.73>

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! Received on Mon Jan 07 2002 - 19:46:50 CST