Multiple schema's or multiple databases

2001-05-22 Thread Sam Roberts
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

RE: Multiple schema's or multiple databases

2001-05-22 Thread Christopher Spence
recipients of list ORACLE-LSubject: Multiple schema's or multiple databases 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 datab

RE: Multiple schema's or multiple databases

2001-05-22 Thread John Lewis
. -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 22, 2001 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple schema's or multiple databases 1.  Is that performance gain absolutely necessary?   What happens if one co

Re: Multiple schema's or multiple databases

2001-05-22 Thread Sam Roberts
- Original Message - From: John Lewis To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 23, 2001 3:36 AM Subject: RE: Multiple schema's or multiple databases Something to ponder. The archive logs are tied to the system. Thus, if you want to recov

RE: Multiple schema's or multiple databases

2001-05-23 Thread Diana_Duncan
cc: Sent by:Fax to: [EMAIL PROTECTED]Subject: RE: Multiple schema's or multiple d

Re: Multiple schema's or multiple databases

2001-05-23 Thread Richard Ji
pients of list ORACLE-L Sent: Wednesday, May 23, 2001 3:36 AM Subject: RE: Multiple schema's or multiple databases Something to ponder. The archive logs are tied to the system. Thus, if you want to recover to a point in time for a multi-schema /one instance system, if one schema gets r