Hi,
There are multiple solutions:
1. You can create different schemas within the same database. Developers
will connect to the same database and work with the schema of their
interest.
2. If solution-1 is not applicable then you can create multiple
databases in the same server. All of them will have their own instance
and the developers may connect to the required instance.
I did not understand your point of concerning about the huge increase of
number of developers in the future, unless you are going to create new
databases for the new users. Is this really a requirement like that??
Thanks & Regards,
Manash Partim Baruah
Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com
-----Original Message-----
From: Rajesh kalaria
[mailto:oracledba-ezmlmshield-x44850549.[Email address protected]
Sent: Thursday, December 27, 2007 3:32 PM
To: LazyDBA Discussion
Subject: More than one database in oracle ??
All,
We want to use oracle as back end for development environment.
We want a centralized location, where all the developers can have their
respective database. Now the problem is one oracle instance can connect
with only one database. We wants instances should be automatically start
when a developer wants to connect with one database. In future the no.
of developers could be increased by a huge no. also. So how and which
type of configuration will be suitable for this types of requirements.
Regards,
Rajesh
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page