[Tips] How to manually expand the tablespace of an Oracle Database

1. First, check the tablespace name and its file selecttablespace_name, file_id, file_name, round (bytes (1024*1024), 0) total_spacefromd

1. First, check the tablespace name and its file select tablespace_name, file_id, file_name, round (bytes/(1024*1024), 0) total_spacefrom d

1. First, check the name and file of the tablespace.

Select tablespace_name, file_id, file_name, round (bytes/(1024*1024), 0) total_spacefrom dba_data_filesorder by tablespace_name;

2. Add data files

Alter tablespace users add datafile '/u01/Oracle/oradata/umail/users02.dbf' size 4000 M autoextend off; alter database datafile '/u01/oracle/oradata/umail/user01.dbf' autoextend off;

3. view the tablespace information after setting

Select. TABLESPACE_NAME,. bytes total, B. bytes used, C. bytes free, (B. BYTES * 100)/. BYTES "% USED", (C. BYTES * 100)/. BYTES "% FREE" from sys. SM $ TS_AVAIL A, SYS. SM $ TS_USED B, SYS. SM $ TS_FREE cwhere. TABLESPACE_NAME = B. TABLESPACE_NAME and. TABLESPACE_NAME = C. TABLESPACE_NAME;

Complete.

,