表空间使用情况及扩展表空间

select tablespace_name, file_id, file_name, 
round(bytes/(1024*1024),0) total_space  
from dba_data_files   where tablespace_name like '%ZMD%'
order by tablespace_name;

ALTER DATABASE DATAFILE 'E:\ORADATA\ZMD\TIPSZMD_DATA.DBF'
RESIZE 8192M;