Oracle table creation process beginner

A friend asked me how to create a database in Oracle? What is the difference between Oracle and other databases? He has too many problems, and I think his simple explanation can satisfy his curiosity about Oracle, so I wrote this article. (Ps: the friend in this article is Comrade xiaomiao from the esframework group of Zhu Wei's brother)

Oracle and mssql are somewhat different. For example, the basic unit of Oracle is tablespace, table, segment, and block.

After Oracle is installed, we use the Oracle client to connect to Oracle. The first thing we can see is the case library. Then the tablespace is under the case database. (In general, initialization data is available for installation. If you want to recreate the case database, we recommend that you do not use initialization data)

When you see the basic structure, you will understand that the tablespace is a large container. To create a table, for example, you need to create a tablespace first.

Before that, we must create a new user to manage the new tablespace. Oracle defines three basic user identities: normal, sysoper, and sysdba. Both sysdba and sysoper are system-level users. Only authorized normal users can directly access the data information in the newly created tablespace.

After creating a user, you can authorize the user by role or directly. Direct authorization is recommended. In some cases, Role authorization may cause indirect problems. I will not detail them here. (If you need it, you can email it to me)

Directly authorize the DBA to manage a tablespace. Then, we can exit the sys system user and log on as the normal user. Then we can create various tables.