2、oracle表空间文件追加
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;