How to add tablespaces in ORACLE

How can I add tablespaces in ORACLE? Many new users who are new to ORACLE databases have mentioned this problem. The following describes how to add a tablespace in ORACLE for your reference.

1. <! -- [Endif] --> execute 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; increase by M to the TABLESPACE of pai_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

Add tablespace in ORACLE:

/D01/dba/vis01data/tx_data15.dbf the number of the newly added tablespace is generally the previous number + 1, that is, 15)
 

Syntax for creating views in Oracle

Statement for creating a tablespace in oracle

Implementation of oracle re-Indexing

Complete Oracle File System Parsing

ORACLE system table and data dictionary View