ORACLE表空间增加文件

查询使用情况

SELECT T.TABLESPACE_NAME,

D.FILE_NAME,

D.AUTOEXTENSIBLE,

D.BYTES,

D.MAXBYTES,

D.STATUS

FROM DBA_TABLESPACES T, DBA_DATA_FILES D

WHERE T.TABLESPACE_NAME = D.TABLESPACE_NAME

ORDER BY TABLESPACE_NAME, FILE_NAME;

查看表空间大小

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;

查看表空间文件大小

SELECT TABLESPACE_NAME,

FILE_ID,

FILE_NAME,

ROUND(BYTES / (1024 * 1024), 0) TOTAL_SPACE

FROM DBA_DATA_FILES

ORDER BY TABLESPACE_NAME;

查看表空间是否自动扩展

select * from dba_data_files where tablespace_name = 'PIMRCS_UAT_DATA';

数据表空间增加数据文件

ALTER TABLESPACE PIMRCS_UAT_DATA ADD DATAFILE '/home/tams/PIMRCS_UAT_DATA_ADD1.bdf' SIZE 30720M autoextend on next 50M maxsize unlimited;