linux oracleËõС»Ø¹ö±í¿Õ¼ä´óСundotbs01.dbf

http://hi.baidu.com/lu_xinzhong/blog/item/4ff92b1725dec505c83d6d09.html
»Ø¹ö±í¿Õ¼ä´óС
-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄUNDO TABLESPACE
Create UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/orcl/UNDOTBS02.DBF' SIZE 100M REUSE AUTOEXTEND ON;
-- ÉèÖÃеıí¿Õ¼äΪϵͳUNDO_TABLESPACE
Alter SYSTEM SET UNDO_TABLESPACE=UNDOTBS2;
-- Drop ¾ÉµÄ±í¿Õ¼ä
Drop TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES; (Íê³Éºóɾ³ý±í¿Õ¼äºÍÊý¾Ý/u01/app/oracle/oradata/orcl/UNDOTBS01.DBF)
Select * from DBA_TABLESPACES;
È»ºó½øÐгöϲÙ×÷£º
-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄUNDO TABLESPACE
Create UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/app/oracle/oradata/orcl/UNDOTBS01.DBF' SIZE 100M REUSE AUTOEXTEND ON;
-- ÉèÖÃеıí¿Õ¼äΪϵͳUNDO_TABLESPACE
Alter SYSTEM SET UNDO_TABLESPACE=UNDOTBS1;
-- Drop ¾ÉµÄ±í¿Õ¼ä
Drop TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES;
--²é¿´ËùÓбí¿Õ¼äµÄÇé¿ö
Select * from DBA_TABLESPACES;
Íê³Éºóɾ³ý/u01/app/oracle/oradata/orcl/UNDOTBS02.DBF¡£
Èç¹ûÁÙʱ±í¿Õ¼äºÜ´ó´¦ÀíµÄ·½·¨ÀàËÆ¡£