Re: One or more Databases

Thanks for clearing this up. It is all new to me as I am typically used to creating applications for a dedicated database which is developed and tested in house, then installed on site for a test / pilot phase before going live.

When producing a new application for a company using Oracle I presume that you would start by getting a copy of the database from the customers server that your application will use. The development work would incorporate keeping the two synchronous if the application being produced interlaced with any existing schemas. And finally it would be deployed on site.

Would you advise having a separate instance for the OEM repository and RMAN?

Regards,
Harry

"Michael A. Howard" <mhoward_at_mahoward.com> wrote in message news:n9jD7.202$%I.292395_at_newsrump.sjc.telocity.net...
> 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 Tue Oct 30 2001 - 03:54:35 CST