Oracle增加表空间

select t.* from sys.dba_data_files t where t.tablespace_name ='EAS_D_YDJT_STANDARD'

select t.* from sys.ora_data_files t where t.tablespace_name ='EAS_D_YDJT_STANDARD'

alter database datafile '+DATADG/orcl/datafile/eas_d_ydjt_standard.ora' resize 4000M

查询表空间select t1.name,t2.name  from v$tablespace t1,v$datafile t2 where t1.ts# = t2.ts#;

查看表大小和使用率
select a.tablespace_name, total, free, total-free as used, substr(free/total * 100, 1, 5) as "FREE%", substr((total - free)/total * 100, 1, 5) as "USED%" from
(select tablespace_name, sum(bytes)/1024/1024 as total from dba_data_files group by tablespace_name) a,
(select tablespace_name, sum(bytes)/1024/1024 as free from dba_free_space group by tablespace_name) b
where a.tablespace_name = b.tablespace_name
order by a.tablespace_name;

select * from dba_data_files t where t.tablespace_name = 'EAS_D_YDJT_STANDARD'

alter database datafile '+DATADG/orcl/datafile/eas_d_ydjt_standard.ora' resize 10240M;

启动sqlplus  / as  sysdba

alter tablespace PACS31 add datafile '+DATADG/orcl/datafile/eas_d_ydjt_standard.ora' size 10240M;

alter tablespace EAS_D_YDJT_STANDARD add datafile '+DATADG/orcl/datafile/eas_d_ydjt_standard1.ora' size 10240M;

增加表空间代码alter tablespace EAS_D_YDJT_STANDARD add datafile '+DATADG/orcl/datafile/eas_d_ydjt_standard1.ora' size 10240M;

Linux的Oracle增加表空间相关操作.docx