Re: "Oracle Server" also include "Oracle Database" ?

From: Charles Goehring <cgoehrin_at_san.rr.com>
Date: Sat, 09 Aug 2003 17:16:20 GMT
Message-ID: <E%9Za.19532$8N.1060739@twister.socal.rr.com>

There are terminology differences between Oracle and SQL Server. For Oracle, the Oracle Server is the RDBMS software. Once you install the software, you, or the "Database Configuration Assistant" issues the "CREATE DATABASE" statement that creates an instance on the machine and creates the data dictionary. You normaly would only have one "database". You can however run "dual instances' to have separate executing servers. That is commonly done to have a development and production system on the same machine. In SQL Server, you commonly create multiple "databases" on the server that are segregated from each other. Not sure of the reasons for doing this on SQL Server.

Chuck

atl- wrote:

> Does "Oracle Server" also include "Oracle Database" ?
> Or does the Database have to be installed on top of the Server ?
> Thanks.
>
>
Received on Sat Aug 09 2003 - 12:16:20 CDT