Re: Listeners, Instances, Ports, ...

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 8 Apr 1998 17:48:01 -0700
Message-ID: <6gh5s1$k7p$1@pebble.ml.org>

In article <352bfdd4.20798899_at_news1.occa.home.net>, JRStern <JRStern_at_primalsys.com> wrote:
>On Wed, 8 Apr 1998 18:19:20 -0400, "Venkat" <vreddy_at_ix.netcom.com>
>wrote:
>>First let me clarify a couple of things. A database in Oracle and SQL
>>Server is not the same thing. Roughly a tablespace in Oracle is equivalent
>>to a database in SS.
>
>A database is also a "namespace" in (Microsoft) SQLServer, so you can
>have a table Customer in each without confusion. Is that true in
>Oracle?

Perhaps a schema would be closer to what other db's call a database. You can have several schemata, each with it's own Customer table - scott.customer, bill.customer and so on.

You need to read the concepts manual and get a clear idea of tablespaces, segments, schemata, and so on. Tables and their indices can (in fact, should) be in different tablespaces, for example. You should get an experienced DBA to help you set things up correctly, before things blow up.

>
>> You cannot have multiple databases with one instance -
>>it's the other way around. Oracle Parallel Server, ...
>
>I've been told repeatedly that one of the new features in Oracle8 was
>that it could, for the first time, support multiple databases in one
>instance. Have I been misinformed?
>

It depends on what you mean by database!

>As for the parallel server, let me get the base product understood
>first.

Thar be dragons...

>
>Josh
>
>
>

--
These opinions are my own and not necessarily those of Information Quest

jgarry@eiq.com                           http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA! Received on Wed Apr 08 1998 - 19:48:01 CDT