Re: Databases and Instances

On Thu, 30 Mar 2000 22:11:00 +0200, Stefan Jahnke <q5665841_at_bonsai.fernuni-hagen.de> wrote:

>I wonder wether it is possible to create one instances, but multiple
>databases that are accessed via the one instance (on the same server)
>like it is possible to do with DB2.

As in multiple schemas? Of course. Since version 3, or even less I suppose.

>seperated bunch of oracle processes per instance with an SGA). But there
>is only one DB that can be mounted and opened per instance. The only

Yeah, but this DB can have perfectly compartmentalized multiple schemas, each one with their own individual security, roles, data areas, index areas, temporary areas, scratch areas, stored procedures, referential integrity, tables, views, indexes, etc,etc. What else do you need? BTW, each individual schema is as closed or as open to others, inside or outside the instance, as you may want to make it.   

>I don't want just database
>links.

And that tells me straight away you want multiple schemas. Go ahead, one single instance and database will do them, as many as you may want. Why complicate the issue with another round of semantics specific to DB2's implementation of the relational model?

But if you really want the separate instances, one for each "database", then go ahead and start another ORACLE instance, from the same ORACLE_HOME. You will be using one single copy of the code in memory, it is all shared. Therefore, no problem again.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Mar 31 2000 - 00:00:00 CST