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.
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!
