oracle±í¿Õ¼ä²Ù×÷

-½¨Á¢±í¿Õ¼ä(oracleÖеÄtablespace(±í¿Õ¼ä)¾ÍÏ൱ÓÚsqlserverµÄdatabase)
CREATE TABLESPACE data01
DATAFILE 'D:\oracle\ora92\oradata\db\DATA01.dbf' SIZE 200M
UNIFORM SIZE 128k;
#Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏΪ64k
--½¨Á¢ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE temp_data
TEMPFILE 'D:\TEMP_DATA.dbf' SIZE 100M
--½¨Á¢Óû§
CREATE USER peter IDENTIFIED BY peter
DEFAULT TABLESPACE data01
TEMPORARY TABLESPACE temp_data;
--¸øÓû§ÊÚȨ
grant connect,resource,dba to peter;
-- ´Ó '½¨Á¢±í¿Õ¼ä' µ½ '½¨Á¢ÁÙʱ±í¿Õ¼ä' µ½ ’½¨Á¢Óû§‘ µ½ ’¸øÓû§ÊÚȨ’ £¬
-- µ½´Ë¾Í¿ÉÒÔÓý¨Á¢µÄÓû§½øÐеǽ£¬È»ºó½¨Á¢tableÁË
-- ²¢ÇÒÒÔij¸öÓû§µÄÉí·Ý½øÐеǽ£¬½øÐб¸·ÝÓ뻹ԭÁË
Ò»¡¢½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01
DATAFILE '/oracle/oradata/db/DATA01.dbf'
SIZE 500M
UNIFORM SIZE 128k; #Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏΪ64k
(×¢Ò⣬±ØÐëÏÈдdatafile²ÅÄÜдsizeºÍuniform size£¬ÒòΪֻÓÐÏÈÖ¸¶¨ÁËÎļþ²ÅÄܹ»Ö¸¶¨ÎļþµÄ´óС£¬ÕâÊÇÒ»¸öÒò¹û¹Øϵ)
¶þ¡¢½¨Á¢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;
drop tablespace temp_data including contents and datafiles;(ɾ³ýÁÙʱ±í¿Õ¼ä)
Áù¡¢À©Õ¹±í¿Õ¼ä
Ê×ÏȲ鿴±í¿Õ¼äµÄÃû×ÖºÍËùÊôÎļþ
select tablespace_name, file_id, file_n