1. 테이블스페이스 확인
출처 : http://blog.naver.com/davelee79/140102855976
set feedback off
set linesize 150
set pagesize 50
col "Tablespace Name" format a20
col "File Name" format a70
col "Total(MB)" format 999,999,999.99
col "Used(MB)" format 999,999,999.99
col "Free(MB)" format 999,999,999.99
col "Free(%)" format 9999.99
select ddf.tablespace_name "Tablespace Name",
ddd.FILE_NAME "File Name",
ddf.bytes/1024/1024 "Total(MB)",
dfs.bytes/1024/1024 "Free(MB)",
round((1 - ((ddf.bytes - dfs.bytes) / ddf.bytes)) * 100, 2) "Free(%)"
from (select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) ddf,
(select tablespace_name, sum(bytes) bytes
from dba_free_space
group by tablespace_name) dfs,
dba_data_files ddd
where ddf.tablespace_name = dfs.tablespace_name and ddf.tablespace_name = ddd.tablespace_name
order by ((ddf.bytes-dfs.bytes)/ddf.bytes) desc
/
2. 테이블스페이스 변경
- 데이터파일 추가
ALTER TABLESPACE TS_CRIDX01 ADD DATAFILE '/home/archive/Tibero/tibero4/database/tibero/TS_CRIDX01_02.dbf' SIZE 200M
- 데이터파일 변경
ALTER DATABASE DATAFILE '/home/archive/Tibero/tibero4/database/tibero/TS_CRIDX01_01.dbf' RESIZE 300M