I
I
iluxa18102018-01-20 23:21:26
Oracle
iluxa1810, 2018-01-20 23:21:26

Creating a new DB in Oracle?

Previously worked with SQL SERVER and the creation of a new database was achieved by calling the CREATE DATABASE command.
Now here I get acquainted with Oracle.
I correctly understand that in Oracle this is done through the DataBase Configuration Assistant? Is it normal that a new database is being created so slowly? In MS SQL, everything was done instantly.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
andreev_aa, 2018-02-21
@andreev_aa

iluxa1810 , DBCA creates a new instance of the database, with its own data files, its own system dictionary.
You can read about comparisons of concepts, for example, here itech-notes.blogspot.ru/2012/10/oracle-ms-sql-serv...
According to this link, the database in SQL Server corresponds to the schema in the Oracle database, and the schema is the objects of a specific user.
That is, you can have one instance (all database files) and one database instance (memory structures), in which several schemas (users) will be created with the same set of tables, procedures, packages, and so on.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question