Add tablespace in Oracle

1,
Run the following SQL statement to find the path of the data file that stores the tablespace:

-- Sep 28,200 8
Eleven. Xu

Select
DDF. file_name

From dba_data_files DDF

Where DDF. tablespace_name = 'apps _ ts_tx_data'

2. log on to PL/SQL developer with system/Manager

Create a command window

Run the following SQL statement:

Alter tablespace pai_ts_tx_data add datafile
'/D01/DBA/vis01data/tx_data14.dbf' size 100 m ; (Add 100 m To tablespace _ ts_tx_data)

Note: run the preceding command to add the tx_data **. DBF file. ** replace the number in "No SQL result exists". Generally, add 1 to the maximum number in the SQL query.

 

For example:

Through 1, the following data files are found in the currently performance_ts_tx_data tablespace:

/D01/DBA/vis01data/tx_data1.dbf

/D01/DBA/vis01data/tx_data2.dbf

...

/D01/DBA/vis01data/tx_data14.dbf

Use 2 to add a new tablespace:

/D01/DBA/vis01data/tx_data15.dbf
(The number of the newly added tablespace is generally the number of the previous number plus 1, that is, 15)