--查询表空间大小
SELECT total.tablespace_name,
Round(total.MB, 2) AS Total_MB,
Round(total.MB - free.MB, 2) AS Used_MB,
Round(( 1 - free.MB / total.MB ) * 100, 2)
|| '%' AS Used_Pct
FROM (SELECT tablespace_name,
Sum(bytes) / 1024 / 1024 AS MB
FROM dba_free_space
GROUP BY tablespace_name) free,
(SELECT tablespace_name,
Sum(bytes) / 1024 / 1024 AS MB
FROM dba_data_files
GROUP BY tablespace_name) total
WHERE free.tablespace_name = total.tablespace_name;
--表空间的datafile要根据数据库安装过程实际的路径
--创建表空
--查表空间目录 :
select * from dba_data_files
--
--扩容根据实际大小来处理
--size指要扩充的大小
ALTER TABLESPACE 表空间名称 ADD DATAFILE '文件路径\表空间名称+日期.DBF' SIZE 2048M;