How to add tablespace files in oracle

In Oracle, you can use the alter command to add table space files. The syntax is "alter tablespace table space name add datafile file path size file size;".

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

How to add table space files in oracle

First query how many table spaces there are in the database

Then use the sql statement in the following figure to Query the usage of the table space

Then query the location where the data files of the corresponding table space are stored, as shown below

After querying the storage location, add the data file to the table space through the statement in the figure below

After the addition is completed, query the data file of the table space and you will find that the data file is The original one has now become two, which proves that the data file was added successfully

And when the size of the table space was queried, it was found that the table space was increased from the original 500M The size has now been changed to 700M. The increased size is the size of the data file just added

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to add tablespace files in oracle. For more information, please follow other related articles on the PHP Chinese website!