Get the App
SLTechnology News&Howtos  ›  Database  › 

Oracle beginner's concept

Shulou Source: shulou.com Published: 2022-06-01 14:44:47 10月02日 Update

Here are some concepts that I first learned from oracle that I understand by myself, which may be misconceptions.

Database can be built with graphical interface under 1.windows.

See Baidu: http://jingyan.baidu.com/article/90bc8fc80c01f2f653640c1f.html

During creation, you can specify the database name, as well as SID (service name), or instance name.

two。 A database is a set of files that can be accessed only when the instance (service) is started.

3. You can start multiple instances to point to the same database.

4. A database can be stored in one or more database table spaces.

5. Database is a physical concept, that is, stored data. An instance is a logical concept that can be understood as a database service (the process can be seen by the Windows task manager).

6. There is no essential difference between .bdf and .ora files, which can be used when building tablespaces. It is recommended to use tablespace files with .bdf suffix, which is more professional.

Tags: Data database instance concept file space service multiple that is specialty task only suffix graphics suggestion pointing essence physics interface process Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Shulou Information Shulou Tech Info Apple Microsoft