RE: Re:Public synonyms with multiple packages

From: Yttri, Lisa <lisa.yttri_at_cnh.com>
Date: Fri, 5 Jan 2001 15:33:00 -0600
Message-Id: <10732.125904@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_01C0775F.6A9F5820
Content-Type: text/plain

This is a good question and I'd really like some additional input. Does everyone create a separate instance each time you install a vendor package? If so, do you have multiple instances running on the same machine (ie. we are running Unix, and our management thinks fewer bigger machines is much better than many smaller ones)? Because of our management pressure, we have only one production instance with several different tablespaces for the various packages. I'm guessing this is only the first of many problems we could run into. Any words of wisdom are greatly appreciated!

Thanks - and have a great weekend -
Lisa

From: Eric D. Pierce
To: Multiple recipients of list ORACLE-L Subject: Re:Public synonyms with multiple packages Date: Wednesday, December 20, 2000 2:40PM

do people actually mingle multiple schemas from different packages/vendors in one instance? seems yuk.
ep

On 20 Dec 2000, at 11:10, dgoulet_at_vicr.com wrote:

Date sent:      	Wed, 20 Dec 2000 11:10:31 -0800
To:             	Multiple recipients of list ORACLE-L

<ORACLE-L_at_fatcity.com>

> Only one that I know of, find a new vendor.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Yttri; Lisa" <lisa.yttri_at_cnh.com>
> Date:       12/20/2000 9:20 AM
>
> 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?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Author: Eric D. Pierce
INET: PierceED_at_csus.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
 --------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C0775F.6A9F5820
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>RE: Re:Public synonyms with multiple packages</TITLE>
</HEAD>
<BODY>

This is a good question and I'd really like some =
additional input.  Does everyone create a separate instance each = time you install a vendor package?  If so, do you have multiple = instances running on the same machine (ie. we are running Unix, and our = management thinks fewer bigger machines is much better than many = smaller ones)?  Because of our management pressure, we have only = one production instance with several different tablespaces for the = various packages.  I'm guessing this is only the first of many = problems we could run into.  Any words of wisdom are greatly = appreciated!

Thanks - and have a great weekend -
 Lisa
  ----------
 From: Eric D. Pierce
 To: Multiple recipients of list ORACLE-L
 Subject: Re:Public synonyms with multiple =
packages
 Date: Wednesday, December 20, 2000 2:40PM


do people actually mingle multiple schemas =

from</FONT>


<BR><FONT SIZE=3D2>different packages/vendors in one instance?</FONT>

<BR><FONT SIZE=3D2>seems yuk.</FONT>

<BR><FONT SIZE=3D2>ep</FONT>


 

On 20 Dec 2000, at 11:10, dgoulet_at_vicr.com =
wrote:


Date sent:      =
        Wed, 20 Dec 2000 11:10:31 = -0800
 To:          =            Multiple = recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>


> Only one that I know of, find a new =
vendor.
 >
 > Dick Goulet
 >
 > ____________________Reply =

Separator____________________</FONT>

 > Author: "Yttri; Lisa" =
<lisa.yttri_at_cnh.com>
 > Date:       =
12/20/2000 9:20 AM
 >
 > I'd like to get some ideas on how to handle =

this problem</FONT>

 >
 > 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?


 --
 Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>
  --
 Author: Eric D. Pierce
   INET: PierceED_at_csus.edu


Fat City Network Services    -- (858) =
538-5051  FAX: (858) 538-5051
 San Diego, =

California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>&nbsp;---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing list, send an =
E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in
 the message BODY, include a line containing: UNSUB =
ORACLE-L
 (or the name of mailing list you want to be removed =
from).  You may Received on Fri Jan 05 2001 - 15:33:00 CST