- 扩展表空间
- 首先查看表空间的名字和所属文件
- select tablespace_name, file_id, file_name,
- round(bytes/(1024*1024),0) total_space
- from dba_data_files
- order by tablespace_name;
- 1.增加数据文件
- ALTER TABLESPACE game
- ADD DATAFILE '/oracle/oradata/db/GAME02.dbf' SIZE 1000M;
- 2.手动增加数据文件尺寸
- ALTER DATABASE DATAFILE '/oracle/oradata/db/GAME.dbf'
- RESIZE 4000M;
- 3.设定数据文件自动扩展
- ALTER DATABASE DATAFILE '/oracle/oradata/db/GAME.dbf
- AUTOEXTEND ON NEXT 100M
- MAXSIZE 10000M;
- 设定后查看表空间信息
- SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
- (B.BYTES*100)/A.BYTES "% USED",(C.BYTES*100)/A.BYTES "% FREE"
- FROM SYS.SM$TS_AVAIL A,SYS.SM$TS_USED B,SYS.SM$TS_FREE C
- WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.TABLESPACE_NAME=C.TABLESPACE_NAME;
- --该片段来自于http://www.codesnippet.cn/detail/150320132435.html
来源: http://www.codesnippet.cn/detail/150320132435.html