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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
