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>
Date: Tue, 24 Jun 2008 08:55:55 -0700 (PDT)
Message-ID: <8b126910-4dec-46f2-91fa-6dad77e98b93@t54g2000hsg.googlegroups.com>
Hi,
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