Re: Oracle & MS SQL server - Similarities and differences

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 02 Sep 2002 20:37:36 GMT
Message-ID: <3D73CBF0.8F1E3BC3@exesolutions.com>

Niall Litchfield wrote:

> <snipped>

> > In SQL 2000 tables, views, indexes, procedures etc exist within a
> > database whereas in Oracle they exist within a schema.
>
> With the exception for the source code to procedures yes this is correct.
> >
> > Is there a place where I can migrate from SQL 2000 and Oracle with
> > respect to the concepts. :-)
>

Given the common misuse of the terms I would say "no" rather than "yes". A schema in Oracle is equivalent to a database in SQL Server. They are two different words for the same thing.

The source code for procedure is stored in the SYSTEM tablespace ... but in terms of the question being asked ... the object is still owned by the schema, not the database (in Oracle).

Daniel Morgan Received on Mon Sep 02 2002 - 15:37:36 CDT