Oracle database Table Space Expansion method

1. Check the location of the table space on the physical disk, and pay attention to the login using SYSDBA's account.

SELECTfile_id  file_name round/(1024x768 * 1024x768 0   from ORDER by

2. The table space that needs to be expanded is Dw_stg_tbs, the current file allocation sequence number is DW_STG_TBS20.DBF,

So in the next file to add the name starting from 21, we add 20 files at a time, the script is as follows.

The initial allocation space for each file set is 7g, Autoextend on is automatically growing, and Oracle single file size is no more than 32g.

--increase the stage layer table spaceAltertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs21.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs22.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs23.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs24.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs25.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs26.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs27.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs28.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs29.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs30.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs31.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs32.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs33.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs34.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs35.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs36.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs37.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs38.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs39.dbf'Size 7167M Autoextend on ;Altertablespace Dw_stg_tbsAddDataFile'/u01/app/oracle/oradata/crm001/dw_stg_tbs40.dbf'Size 7167M Autoextend on;

3. The above SQL is executed in PL-SQL and the query results are as follows:

4. Query table space size using an SQL statement from another article in this blog [Oracle database storage usage query]

Oracle database Table Space Expansion method