oracle 添加表空间

alter tablespace admin add
datafile '/u01/app/oracle/oradata/orcl/admin_2.dbf' size 1g autoextend on next 200m;

 

create tablespace WENTAPP datafile 'D:\ORADATAORCL\WENTAPP_1.DBF' size 4000M

--1、查看表空间的名称及大小 
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size 
FROM dba_tablespaces t, dba_data_files d 
WHERE t.tablespace_name = d.tablespace_name 
GROUP BY t.tablespace_name; 
--2、查看表空间物理文件的名称及大小 
SELECT tablespace_name, 
file_id, 
file_name, 
round(bytes / (1024 * 1024), 0) total_space 
FROM dba_data_files 
ORDER BY tablespace_name;