What is Oracle's default tablespace?

In Oracle, the default table space is a storage location where the user does not specify the table space location when creating it. You can use the ALTER command to modify the table space. The syntax is "ALTER DATABASE DEFAULT TABLESPACE users;".

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

What is the oracle default table space?

In oracle9i, all users created without the DEFAULT TABLESPACE clause will use the SYSTEM table space as their default table space. It is also not possible to specify a default tablespace for the database.

In Oracle 10g, the database-level default table space USERS is defined. If the default table space is not defined when creating a user, the database-level default table space will be regarded as its own default table space.

Before 10g, the system table space (SYSTEMS) was regarded as the default table space. This is very unreasonable.

You can use the following command to view the default table space:

/* Formatted on 2011/12/19 15:57:48(QP5 v5.185.11230.41888) */  
SELECT PROPERTY_VALUE  
  FROM database_properties  
 WHERE PROPERTY_NAME = 'DEFAULT_PERMANENT_TABLESPACE'

You can use the following command to modify the default table space:

ALTER DATABASE DEFAULT TABLESPACE users;

Here are a few things to note:

1. If we specify a default table space when creating a user, then after modifying the default table space, the previous user's default table space will also change.

2. If we do not specify the user table space when creating a user, the default table space of DB will also be used by default. At this time, if we modify the default table space of DB, the user's table space will also be damaged. Change.

3. If we specify that the user's table space is another table space when creating a user, then our modification of the DB's default table space will not affect the user's table space.

4. The default table space of DB cannot be deleted unless the default table space is pointed to other table spaces.

5. If the user's default table space points to another table space, when the table space is dropped, the user's default table space will automatically point to the DB's default table space.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of What is Oracle's default tablespace?. For more information, please follow other related articles on the PHP Chinese website!