Different databases or different schemas?

From: <alessandro.rossi74_at_gmail.com>
Date: Tue, 24 Jun 2008 08:55:55 -0700 (PDT)
Message-ID: <8b126910-4dec-46f2-91fa-6dad77e98b93@t54g2000hsg.googlegroups.com>

Even if I'm using Oracle since some year, I have some (many?) doubts about the use of differents schema instead of different DBs. Generally to manage a test environment, a development enviroment and a production environment, I create 3 different databases on the same oracle instance (MYDB_TEST, MYDB_PROD, MYDB_DEV). But I was thinking if to create only 1 database and 3 different schemas for test, developing and production on the same database, could be a better solution.

Does anybody can suggests me which is the best solution and which are the advantages (and disadvantages) of the two choices?

Thank you in advance
Alessandro Rossi Received on Tue Jun 24 2008 - 10:55:55 CDT

Original text of this message