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;

3、临时表空间追加

ADD tempFILE

ALTER TABLESPACE TEMP_DM_SPACE ADD tempFILE  '/u01/app/oracle/oradata/IFRSPUAT/TEMP_DM_SPACE2.DBF' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE unlimited;