Create a tablespace in Oracle and test it with the user

Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed in the memory. However, when sorting large data volumes, the memory is insufficient.

Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed in the memory. However, when sorting large data volumes, the memory is insufficient.

The Oracle tablespace is described as follows:

Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed in the memory, but when sorting large data volumes, when the memory is not enough, temporary tablespace will be used. The table is not stored here, which is similar to the Virtual Memory concept in the operating system.

Data Table space: it is the tablespace that stores tables, indexes, and other data files. It is better to divide the tables and indexes into different tablespaces, so the performance will be much better.

User-specified tablespace: in fact, it only sets a default value for the tablespace during table creation. That is to say, if the user does not specify the tablespace during table creation, it is stored in the user-specified tablespace by default, however, if a tablespace is specified, other tablespaces can still be used. In addition, if other users are granted permissions, they can still use the tablespace.

As a general user, we can create a data table space and assign it to a user.

-- Create a user

Create user eh identified by "123 ";

-- Grant Permissions

Grant connect, resource to eh;

-- Create a tablespace

Create tablespace eh_temp_tablespace

Datafile 'd:/oracle_tablespace/eh_temp_tablespace.dbf'

Size 800 m

Autoextend on next 5 m

Maxsize 3000 m

-- Grant users the permission to use tablespaces.

Alter user eh quota unlimited on eh_temp_tablespace

Or alter user eh quota * M on eh_temp_tablespace

-- Delete a tablespace

Drop tablespace eh_temp_tablespace including contents and datafiles

Oracle 11g tablespace dbf File migration

Solutions for moving Oracle tablespace data files

Deleting temporary tablespace ORA-25152 Error

Oracle tablespace growth exception solution: Another example

Three parameters of Oracle tablespace Offline

Use of encrypted tablespace under Oracle 11 GB