select tablespace_name,sum(bytes)/1024/1024 from dba_data_files
group by tablespace_name;
查看各个表空间大小
select tablespace_name,sum(bytes)/1024/1024 from dba_free_space
group by tablespace_name;
查看表空间剩余大小
alter tablespace OA_NEW add datafile 'D:\sql\oracle\oracledata\OA_NEW2.ora' size 200m;
增大表空间