Public synonyms with multiple packages

From: Yttri, Lisa <lisa.yttri_at_cnh.com>
Date: Wed, 20 Dec 2000 11:19:00 -0600
Message-Id: <10716.125012@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C06AA9.3B7C5478
Content-Type: text/plain

I'd like to get some ideas on how to handle this problem

We have an oracle instance which happens to have multiple vendor packages installed. The problem is, a couple of these packages have a table with the same name. The first one has created a public synonym and, of course, when the second one tried to create one it couldn't. Is there any solution to this other than running these packages on separate oracle instances?

Thanks in advance -
Lisa

------_=_NextPart_001_01C06AA9.3B7C5478
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Public synonyms with multiple packages</TITLE>
</HEAD>
<BODY>

I'd like to get some ideas on how to handle this =
problem


We have an oracle instance which happens to have =
multiple vendor packages installed.  The problem is, a couple of = these packages have a table with the same name.  The first one has = created a public synonym and, of course, when the second one tried to = create one it couldn't.  Is there any solution to this other than = running these packages on separate oracle instances?

Thanks in advance -
 Lisa


</BODY>
</HTML>
Received on Wed Dec 20 2000 - 11:19:00 CST