解释“创建数据库"时，Oracle和Mysql有什么区别? [英] What's the difference between Oracle and Mysql when interpreting "Create Database "?

问题描述

我曾经使用mysql，并且在mysql数据库中保存表，但是这些概念不适用于oracle，因此我不太了解它们之间的区别.

I used to use mysql, and in mysql database hold tables, but these concepts doesn't apply to oracle, so I don't quite understand the differences.

更新:我面临的问题是，我需要从Mysql迁移到Oracle. 我有两个名为A和B的交换数据库，在Mysql中，所有表都在其对应的数据库中. 在mysql数据库中是一个逻辑概念，它使用数据库来保存表，在oracle数据库中是物理概念，我不知道该如何在oracle中进行设计. 我是否需要使用"CREATE DATABASE"在oracle中创建两个数据库才能达到相同的效果?

Update: The problem I am facing is, I need to do migration from Mysql to Oracle. I have two switching databases called A and B, in Mysql all the tables are in their corresponding databases. In mysql database is a logical concept, it use database to hold tables, in oracle database is physical concept, I don't know how to design this in oracle. Do I need to use "CREATE DATABASE" to create two databases in oracle to achieve the same effect?

推荐答案

要回答您的问题，您想创建一个架构(CREATE USER)而不是实例/数据库(CREATE DATABASE).

To answer your question you want to create a schema (CREATE USER) not an instance/database (CREATE DATABASE).

Oracle对数据库的定义是磁盘上的文件.这些可以在实例(Real Application Clusters)之间共享，或者只能由单个实例使用(例如，在同一台服务器上最常见).

The Oracle definition of a database is the files on disk. These can be shared between instances (Real Application Clusters) or only used by a single instance (on the same server for example, the most common).

背景:数据库供应商之间数据库"的概念不同.作为Oracle DBA，与来自MySQL，DB2，SQL Server背景的人交谈时要小心，他们在Oracle中所谓的数据库"是用户/架构(用户与架构之间的差异是架构包含表和用户只是一个登录名).每当有人(尤其是开发人员)在什么情况下使用数据库"一词时.

Background: The concept of "database" is different between database vendors. As an Oracle DBA I'm careful when talking to someone who is from an MySQL, DB2, SQL Server background, what they call a "database" in Oracle is a user/schema (difference between user and schema being a schema contains tables and a user is only a login). Whenever someone, developer especially, uses the word "database" question in what context.

这篇关于解释“创建数据库"时，Oracle和Mysql有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！