Re: Different databases or different schemas?

From: Mark D Powell <>
Date: Tue, 24 Jun 2008 10:33:31 -0700 (PDT)
Message-ID: <>

On Jun 24, 11:55 am, wrote:
> 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

An Oracle instance supports only one Oracle database at a time, ever.

If you want three databases: test, development, and production you will have three instances.

Using separate databases for test, development, and production allows separation of resources (disk, server) so that test and development do not interfere with the production database performance. It also allows the use of separate Oracle Homes so that you can test a new release using the test database before bringing production up on a new release.

HTH -- Mark D Powell -- Received on Tue Jun 24 2008 - 12:33:31 CDT

Original text of this message