Can one Oracle user have multiple table spaces?

A user in Oracle can have multiple table spaces, but there is only one default table space. When creating tables, views, indexes, etc. without specifying a table space, they will be stored in the default table space; a user can Use one or more table spaces, and a table space can also be used by multiple users.

The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.

Does a user in Oracle have multiple table spaces?

A user can manage many table spaces at the same time, but there is only one default table space. When creating tables, views, indexes, etc., no table is specified. space will be stored in the default table space.

A user can use one or more table spaces, and a table space can also be used by multiple users. There is no affiliation relationship between users and table spaces. Table spaces are a logical concept used to manage data storage. Table spaces are only related to data files. Data files are physical. One table space can contain multiple data files, and one data file only Can belong to a table space.

The relationship between table space and user

When creating a user, a user can only specify one table space. Multiple users can specify the same table space. Yes 1: When N

accesses the table space, the user must be authorized to access it. Yes N: N

Table space

Creating a table space will create a data file on the physical disk as a database object (user, table, stored procedure, etc.) The physical storage space;

A table space can only belong to one database. All database objects are stored in the specified table space. But it mainly stores tables, so it is called table space.

All user data in oracle is stored in table spaces

Table space (tablespace) is a logical division of the database. Each database has at least one table space (called SYSTEM table Space)

Table space is built on one or more data files;

Different table spaces have different permission controls. The user has full control permissions on table space A, but may only have query permissions on table space B, and does not even have permission to connect.

User

To create a user, you must specify a table space for it. If the default table space is not explicitly specified, it is specified as the users table space; after creating the user, you can On the user, create tables, stored procedures and other database objects;

A user has a default space

Multiple users can share a default space

1), the same In a database use case, the user name cannot be repeated

2). Tables with the same name can be created in different users

3). After the table space is created, a user must be created before it can be used, because any Database objects need to be established on a data user

4). Users with DBA permissions can directly access the database objects of other users. Otherwise, relevant user authorization is required

5). Access other users The database object needs to be added with the user name of the user to whom the object belongs

Oracle manages and stores data by users and table spaces. However, the table is not queried by the table space, but by the user. Because different users can create tables with the same name in the same table space

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of Can one Oracle user have multiple table spaces?. For more information, please follow other related articles on the PHP Chinese website!