查询所有表空间以及大小
SELECT SUM(bytes) / (1024 * 1024) AS free_space, tablespace_name
FROM dba_free_space
GROUP BY tablespace_name;
查询表空间的存储路径
select file_name from dba_data_files where tablespace_name = 'HISEMRDB'
SELECT FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE FROM dba_data_files;
添加表空间并自动增长,每次增加500m.
ALTER TABLESPACE hisemrdb ADD DATAFILE '/mnt/oracle/data/hisemrdb3.dbf' SIZE 500M autoextend on next 500M