From dgoulet@vicr.com Tue, 22 May 2001 12:00:09 -0700 From: dgoulet@vicr.com Date: Tue, 22 May 2001 12:00:09 -0700 Subject: Re:Multiple schema's or multiple databases Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 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

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

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@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@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).