ORACLE ±í¿Õ¼ä²Ù×÷×ܽá

oracle±í¿Õ¼ä²Ù×÷Ïê½â
Ò»¡¢½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01
DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M
UNIFORM SIZE 128k;
¶þ¡¢½¨Á¢UNDO±í¿Õ¼ä
CREATE UNDO TABLESPACE UNDOTBS02
DATAFILE '/oracle/oradata/db/UNDOTBS02.dbf' SIZE 50M
#×¢Ò⣺ÔÚOPEN״̬ÏÂijЩʱ¿ÌÖ»ÄÜÓÃÒ»¸öUNDO±í¿Õ¼ä£¬Èç¹ûÒªÓÃн¨µÄ±í¿Õ¼ä£¬±ØÐëÇл»µ½¸Ã±í¿Õ¼ä:
ALTER SYSTEM SET undo_tablespace=UNDOTBS02;
Èý¡¢½¨Á¢ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE temp_data
TEMPFILE '/oracle/oradata/db/TEMP_DATA.dbf' SIZE 50M
ËÄ¡¢¸Ä±ä±í¿Õ¼ä״̬
1.ʹ±í¿Õ¼äÍÑ»ú
ALTER TABLESPACE game OFFLINE;
Èç¹ûÊÇÒâÍâɾ³ýÁËÊý¾ÝÎļþ£¬Ôò±ØÐë´øÓÐRECOVERÑ¡Ïî
ALTER TABLESPACE game OFFLINE FOR RECOVER;
2.ʹ±í¿Õ¼äÁª»ú
ALTER TABLESPACE game ONLINE;
3.ʹÊý¾ÝÎļþÍÑ»ú
ALTER DATABASE DATAFILE 3 OFFLINE;
4.ʹÊý¾ÝÎļþÁª»ú
ALTER DATABASE DATAFILE 3 ONLINE;
5.ʹ±í¿Õ¼äÖ»¶Á
ALTER TABLESPACE game READ ONLY;
6.ʹ±í¿Õ¼ä¿É¶Áд
ALTER TABLESPACE game READ WRITE;
Î塢ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING CONTENTS AND DATAFILES;
Áù¡¢À©Õ¹±í¿Õ¼ä
Ê×ÏȲ鿴±í¿Õ¼äµÄÃû×ÖºÍËùÊôÎļþ
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;