oracle增加表空间的Sql语句

select * from dba_data_files;

select file_name,tablespace_name,bytes/1024/1024 M from dba_data_files;

//创建
create tablespace ts_px
datafile ‘G:\darewaysoftware\oracle\oradata\orcl ts_px_1.dat’ size 10M;

//追加表空间
alter tablespace ts_px add datafile ‘G:\darewaysoftware\oracle\oradata\orcl ts_px_2.dat’ size 10M;

select tablespace_name, sum(bytes)/1024/1024 MB from dba_data_files group by tablespace_name;