Re:Multiple schema's or multiple databases

From: <dgoulet_at_vicr.com>
Date: Tue, 22 May 2001 12:00:09 -0700
Message-ID: <F001.0030B443.20010522115536@fatcity.com>

Sam,

Well aquatinted with Maximo, nice little product, though it's not an EPR system. It's a facilities/equipment maintenance tracking/scheduling system. It's either client server or web based & it loves handhelds and wireless stuff. The interface is between the purchasing, receiving/inventory and financial areas. Basically a tech can say that he/she needs a particular part to fix something. If it's on-hand Maximo allows the host ERP system to issue the part from inventory or else it creates a requirement inside the purchasing module. It also does something in the financial area to indicate how many manhours and part dollars have been expended against the particular item of equipment or facility for depreciation purposes (most of this does not make any sense to me, but then I'm not a 'bean counter' either). At anyrate, keep it all in the same instance. Having db links does slow it down, although it still runs very well. Also, look at consolidating into one schema for Maximo if possible. It makes for better cross facilities reporting.

Dick Goulet

____________________Reply Separator____________________
Author: Sam Roberts <rabbit_at_emirates.net.ae>
Date:       5/22/2001 9:40 AM

Oracle 8.1.6 and Solaris
I'm going to inherit production databases when I start my new job next week. I gather that the production database consists of 8 schema's (8 companies) that are all in one database. Its an ERP package called Maximo and it interfaces to Financials 11i databases (don't know if this is multiple databases or schema's yet).
Apparently there is some data passing between companies and multiple schema's perform better than using database links with multiple databases, and this is the reason for multiple schema's.
Does anyone have an opinion on this. If I'd have done it I would have done multiple databases as they are separate companies, but I'm open to comments as not quite got my head round it yet, plus I've been vacationing (partying) for 3 weeks.

Thanx

Sam

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=2>Oracle 8.1.6 and Solaris</FONT></DIV>
<DIV><FONT size=2>I'm going to inherit production databases when I start my new
job next week. I gather that the production database consists of 8 schema's (8 companies) that are all in one database. Its an ERP package called Maximo and it

interfaces to Financials 11i databases (don't know if this is multiple databases

or schema's yet).</FONT></DIV>
<DIV><FONT size=2>Apparently there is some data passing between companies and
multiple schema's perform better than using database links with multiple databases, and this is the reason for multiple schema's.</FONT></DIV>
<DIV><FONT size=2>Does anyone have an opinion on this. If I'd have done it I
would have done multiple databases as they are separate companies, but I'm open to comments as not quite got my head round it yet, plus I've been vacationing (partying) for 3 weeks.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Thanx</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>Sam</FONT></DIV>
<DIV><FONT size=2><BR><BR><BR><BR><BR> </DIV></FONT></BODY></HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

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).

Received on Tue May 22 2001 - 14:00:09 CDT