Re: Oracle Instances for a new application

Thanks.

I understand what you say, I was looking however for guidelines. I realize I could put a new schema into the old instance, but what predicates whether a new instance is appropriate or not?

One issue is ... "I think" ... is are there resouce requirements that make extra instances bad unless absolutely necessary? Also, since the databases are completely different, should the table spaces be setup differently?

Thanks so much for your time,

Jeff Kish

On 22 Nov 1997 22:46:02 GMT, "John Roberts" <jrobert1_at_netcomuk.co.uk> wrote:

>Jeff,
>
>you don't need a new instance here - all you need is a new schema. A schema
>is just an Oracle user with a collection of tables. A database can hold a
>number of schemas e.g. the one you have for your current application and
>the one you may create for your new application.
>
>Maybe some terminology will help :
>
>a Database is just a collection of files that holds data
>
>an Instance is a collection of operating system processes that makes it
>possible to access a Database.
>
>A Schema is a collection of tables, indexes, views etc. that holds data for
>a specific purpose e.g. an application.
>
>As long as you have similar up and down times for the 2 applications, you
>can use the same instance and database - you just need to point your users
>at different schemas.
>
>Hope this helps ( if not, come right on back )
>
>
>Regards
>
>
>John Roberts
>
>
>
>Jeff Kish <ait_at_concentric.net> wrote in article
><3471e594.21559721_at_news.concentric.net>...
>> Hello.
>>
>> Could someone advise me here?
>>
>> We have a developed application that uses Oracle.
>> We have, of course, no D.B.A.
>> Now there is a specification for a new application that will use a
>> completely new Oracle database (all new tables).
>>
>> Our old one used the default instance (ORCL).
>>
>> We are running the server on NT 3.51
>>
>> How can I tell
>>
>> 1. Should I create a new instance for this new database? (How do I
>> know it is appropriate given my current
>> application/database/machine/server)
>>
>> 2. If so, how should I determine the parameters and more basically
>> 3. How do I create a new instance?
>>
>>
>> Thanks, Jeff Kish
>>
Received on Mon Nov 24 1997 - 00:00:00 CST