Re: When would you ever need two databases on one machine?

How about where you have a production database and a test database and you want to keep everything except the database name exactly the same - same tables, same tablespaces, same schema owner, etc, etc. This makes setting up test databases relatively easy. It also makes it easy to move databases from one server to another and to size init.ora parameters to the needs of each specific database. This, by the way, is the preferred way to set up multiple Peoplesoft databases.

On Tue, 4 Jan 2000 20:04:42 -0500, "Brad Czika" <bczika_at_mindspring.com> wrote:

>I can't find it anywhere but there must be a good reason. Isn't it enough to
>just have several tablespaces in the same database?
>
>Thanks,
>Brad
>
Received on Tue Jan 04 2000 - 23:11:08 CST