Oracle中的架构是否等同于Microsoft SQL Server中的数据库? [英] Is Schema in Oracle is equivalent to Database in Microsoft SQL Server?

问题描述

我是Oracle数据库的新手，我想在Oracle中创建一个数据库.我按照以下链接创建了一个数据库:

I am new to Oracle database and I wanted to create a database in Oracle. I followed this link to create a database:

http://www.fehily.com/books/createdb/createdb_oracle_11g_2.html

在Microsoft SQL Server中，当我们创建数据库时，我们使用create database命令，并且数据库创建是瞬时的(在几分之一秒内)，但是上面链接中描述的数据库工具花费了几分钟来创建数据库.数据库.在Oracle中创建数据库会这么慢吗?

In Microsoft SQL Server, when we create a database, we use the create database command and the database creation is instantaneous [within fraction of seconds], but the Database Tool as described in link above took couple of minutes to create the database. Is database creation in Oracle this much slower?

搜索更多有关它的信息，我感到使用Oracle以上工具创建的该数据库不等同于我们在SQL Server中创建的数据库.而是，oracle中的架构/用户似乎等同于SQL Server中的数据库.是真的吗?

Searching more about it, I have a feeling that this database created using above tool in Oracle is not equivalent to the database we create in SQL Server. Rather, the schema/user in oracle is appearing to be equivalent to database in SQL Server. Is it true?

那么，如果我想在Oracle中使用多个数据库，是否要创建一个数据库，然后在该数据库中创建多个模式?那那些模式是我的数据库吗?

So, If I want multiple databases in Oracle, do I create a single database and then multiple schemas inside that single database? And then are those multiple Schemas are my databases?

我对这一切感到非常困惑.有人可以请我参考一篇不错的文章/书，其中详细介绍了oracle中的这些内容吗?

I am very much confused about all this. Can someone please refer me to a nice article/book that explains these things in oracle in detail?

推荐答案

对于大多数用途，是的，您确实可以将SQL Server数据库映射到Oracle模式(= user).

For most purposes, yes you would indeed map a SQL server database to an Oracle schema (=user).

Oracle中的术语数据库"与SQL Server中的含义不同.从技术角度来看，Oracle数据库"更像是SQL Server实例/安装，而不是SQL Server中的数据库".

The term "database" in Oracle does not mean the same as in SQL Server. An Oracle "database" (from a technical point of view) is more like a SQL Server instance/installation, rather than a "database" in SQL Server.

SQL Server具有两个级别的名称空间:数据库和架构. Oracle只有一个级别的名称空间:模式(与用户的关系为1:1)

SQL Server has two levels of namespace: database and schema. Whereas Oracle only has a single level of namespaces: a schema (which has a 1:1 relation to a user)

这篇关于Oracle中的架构是否等同于Microsoft SQL Server中的数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！