| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Development projects: Multiple databases v/s multiple schemas
Hi,
We end up doing it both ways at the same time. We have multiple development instances and multiple schemas in each instance. We do this because we are running a large ERP system and each test instance has specific testing requirements so we end up replicating multiple instances on the same machine. Beyond that, all the add-on products that we have either developed or purchased lives in each instance under it's own schema.
If I had my choice, I would run one database instance with multiple schemas. This way the resources are only consumed by one instance and your not try to juggle system resources between multiple instances. That can be a problem if your box is already maxed out as one of our development boxes is.
Hope that helped,
-- Joe Frohne Rawson Oaks Consulting http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED]Received on Fri Jun 20 2003 - 08:57:21 CDT
> Hi,
>
> For multiple projects we are planning to have a centralized server(as
> opposed
> to multiple servers, to improve managability) which all the development
> teams
> will use for their backend work.
>
> Now there are 2 ways in which to provide them access.
>
> 1. Have only 1 database for each version of Oracle Server installed and
> create schemas for individual teams for their development work.
> 2. Create a separate DB for each project team.
>
> I want to know the pros and cons for both the approaches.
>
> Any ideas and suggestions are most welcome.
>
> Regards
> Naveen
>
>
> DISCLAIMER:
> This message (including attachment if any) is confidential and may be
> privileged. Before opening attachments please check them for viruses and
> defects. MindTree Consulting Private Limited (MindTree) will not be
> responsible for any viruses or defects or any forwarded attachments
> emanating either from within MindTree or outside. If you have received
> this message by mistake please notify the sender by return e-mail and
> delete this message from your system. Any unauthorized use or
> dissemination of this message in whole or in part is strictly prohibited.
> Please note that e-mails are susceptible to change and MindTree shall not
> be liable for any improper, untimely or incomplete transmission.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Naveen Nahata
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
 |
 |