查看表空间信息
SELECT f.NAME as "表空间文件",
f.BYTES / 1024 / 1024 || 'MB' as "表空间大小",
t.NAME as "表空间名称"
FROM V$DATAFILE f, v$tablespace t
where f.TS# = t.TS#
扩大表空间信息
ALTER DATABASE DATAFILE '表空间文件' RESIZE 5000M;
查看表空间信息
SELECT f.NAME as "表空间文件",
f.BYTES / 1024 / 1024 || 'MB' as "表空间大小",
t.NAME as "表空间名称"
FROM V$DATAFILE f, v$tablespace t
where f.TS# = t.TS#
扩大表空间信息
ALTER DATABASE DATAFILE '表空间文件' RESIZE 5000M;