Re: One or more Databases

Harry

The concepts and parlance between Oracle & SQL Server are a bit different so in SQL server you would have one Server with multiple "databases" (say one for each application).

In Oracle I would do this as separate "schemas" running in a Single Instance.

I would NEVER run production, test and development "databases" on the same server - a production server should be reliable, a development environment may be subject to developers doing things that may cause a production server to slow down or crash.

There are advantages to running Multiple Instances of Oracle on a single server IF that server has sufficient resources to handle the load. Personally I wouldn't consider doing this using a Windows Server but others mileage may vary.

If you need to watch things like table growth etc you probably need to have separate tablespaces (for instance to separate out BLOBs) for those tables or columns of data that need to be watched.

Mike

"harry" <harry_at_home.com> wrote in message news:3bdd2648$0$232$ed9e5944_at_reading.news.pipex.net...
> Hi,
>
> I am new to the world of Oracle though have experience of developing for
> MSSQL. I am wondering what the preferred method of segregating data for
> different systems, apps etc is.
>
> Under MSSQL I would normally have different databases for different
> applications or testing etc. Oracle, from what I can gather normally has
one
> instance running due to the overhead? Therefore I presume you would
> segregate data using different schemas?
>
> Is it typical to create more than one database but only run one at a time?
> Any tips or pointers would be gladly appreciated.
>
> Regards,
> Harry
>
>
Received on Mon Oct 29 2001 - 17:47:37 CST