Oracle Table Space ____oracle

1, the concept of table space
Oracle databases are divided into logical regions called table spaces-the logical structures that form Oracle databases. An Oracle database can have one or more tablespaces, while one table space corresponds to one or more physical database files. The tablespace is the smallest unit of Oracle database recovery, accommodating many database entities, such as tables, views, indexes, clusters, fallback segments, and temporary segments.
Each Oracle database has the system tablespace, which is created automatically when the database is created. The system tablespace must always be online because it contains the basic information required to run the database (data dictionaries for the entire database, online help mechanisms, all fallback segments, temporary segments and bootstrap segments, all user database entities, and tables for other Oracle Software PRODUCT requirements).

2, the role of the table space
It helps DBA users to determine the spatial allocation of database entities, set the space share of database users, control the availability of part of the data in the database, distribute data between different devices to improve performance, and back up and restore data.

When users create their database entities, they must give the table space the appropriate authority, so for a user to manipulate the data in an Oracle database, it should: be granted resource privileges in one or more tablespaces; The default table space is specified; A share of the storage space assigned to the specified table space, the default temporary segment table space is specified, a different table space is established, and the maximum storage capacity is set.