Oracle extended tablespace 1. view All table space usage select B. file_id File ID, B. tablespace_name tablespace name, B. bytes/1024/1024 | 'M', (B. bytes-sum (nvl (. bytes, 0)/1024/1024 | 'M' is used, sum (nvl (. bytes, 0)/1024/1024 | 'M' remaining space, 100-sum (nvl (. bytes, 0)/(B. bytes) * 100 percentage occupied from dba_free_space a, dba_data_files B where. file_id = B. file_id group by B. tablespace_name, B. file_id, B. bytes order by B. file_id; www.2cto.com 2. view the user's default tablespace. SQL: s Elect username, default_tablespace from dba_users; 3. view the data file path and name used by the tablespace to be extended SQL: select * from dba_data_files where tablespace_name like 'users % '; 4. there are two ways to expand a table space: Increase data files and adjust the size or expansion of the current data file. (1) ADD the data file alter tablespace testtbs add datafile 'd:/ora/datafile/users. ora 'size 500 m autoextend on next 50 m maxsize 2000 M; adds a M data file and can be automatically expanded to 2G, each expansion of 50 M. (2) increase the size of the current data file alter database datafile 'd:/ora/datafile/users. ora 'resize 50000 M; or use file_id alter database datafile 10