oracle表空间文件追加

1、查看使用

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;

2、追加表空间

alter tablespace ATR_SPACE add datafile '/home/oracle/u01/oradata/ifrsbca/ATR_SPACE2.DBF'
 size 31G autoextend on next 200M maxsize unlimited;