Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm part of a team of developer and today, we do our developments against an Oracle 11g database installed on our own machine each. I would like to know your point of view about this way of working compared to working with one single Oracle instance, installed on a virtual machine, hosting one schema per developer ? Knowing that one schema represents today more or less 20Gb of data.

What do you think ?

Thanks

share|improve this question

closed as off topic by Dennis, ta.speot.is, Sathya Jan 31 '13 at 10:59

Questions on Super User are expected to relate to computer software or computer hardware within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

1 Answer

What do you think ?

Use whichever configuration is best suited to your environment. For example, your application might not understand schemas so each developer might need their own database.

At work I have both. My local database allows me to do whatever I want whenever I need to, while the remote shared database is used in conjunction with an external system. The data in the shared database needs to be kept in sync with this external system, so each developer taking a copy and running it locally would not work.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.