Oracle 新增表空间文件

ALTER TABLESPACE users  
  
ADD DATAFILE 'D:/oracle/oradata/orcl/users.dbf' SIZE 500M  
  
AUTOEXTEND ON  
  
NEXT 50M  
  
MAXSIZE 2000M; 

Select Tablespace_Name,Sum(bytes)/1024/1024 From Dba_Segments Group By Tablespace_Name