I have started working with mysql earlier, where different database meant completely different database, and I can create delete databases. but when I started to working with oracle, the structure really confused me, the 'database' term means the same in Oracle as Mysql? If not whats the difference? Thanks!
Asked
Active
Viewed 256 times
2
-
[https://db-engines.com/en/system/MySQL%3BOracle] refere this – P Rane Nov 28 '18 at 08:10
-
1Possible duplicate of [Differences between MySQL and Oracle DB](https://stackoverflow.com/questions/4954076/differences-between-mysql-and-oracle-db) – default locale Nov 28 '18 at 09:08
-
Another similar question that deals with the concept of "database" in MySQL and Oracle: https://stackoverflow.com/questions/3540982/whats-the-difference-between-oracle-and-mysql-when-interpreting-create-databas – default locale Nov 28 '18 at 09:18
-
Possible duplicate of [What's the difference between Oracle and Mysql when interpreting "Create Database "?](https://stackoverflow.com/questions/3540982/whats-the-difference-between-oracle-and-mysql-when-interpreting-create-databas) – default locale Jan 09 '19 at 12:07
1 Answers
2
Oracle doc explain the difference (and migration tips):
2.2.5.1 Databases When migrating MySQL databases to Oracle, SQL Developer maps each MySQL database to a tablespace in Oracle. Database objects, such as tables, indexes and views are stored in the respective tablespaces and are referenced from the Oracle schema for the user that owns them.
Ori Marko
- 56,308
- 23
- 131
- 233
-
So in oracle it is actually a single database. and what we mean by database is mysql is considered as tablespaces from different schema? – Simanta Nov 28 '18 at 08:31
-
1