All geek questions in one place

What is the difference between Oracle and Mysql when interpreting "Create Database"?

I used to use mysql, and in the mysql storage tables of the database, but these concepts do not apply to the oracle, so I do not quite understand the differences.

Update. The problem I am facing is to make the switch from Mysql to Oracle. I have two switching databases, called A and B, in Mysql all tables are in the corresponding databases. There is a logical concept in the mysql database, it uses a database to store tables, in the oracle database there is a physical concept, I don’t know how to create it in oracle. Do I need to use "CREATE DATABASE" to create two databases in oracle to achieve the same effect?

+3
source share
2 answers

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

Oracle Database Definition - These are files on disk. They can be shared between instances (Real Application Clusters) or used only by one instance (for example, on the same server).

. " " . Oracle DBA , - MySQL, DB2, SQL Server, , " " Oracle, / ( , , - ). , -, , " " .

+4

Oracle SQL Developer , MySQL Oracle. . , SQL Dev , MySQL Oracl. , . .

:

" MySQL Oracle, SQL Developer MySQL Oracle. , , Oracle , ".

+2

Source: https://habr.com/ru/post/1760975/

More articles:


All Articles