[Oracle] UNDO Tablespace 비우는 방법

원본 링크 : http://banggucha.tistory.com/entry/Tip-UNDO-Full-발생-시

 

 

1. 임시 undotbs02번 생성

CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/oradata/undotbs02.dbf' SIZE 10M;   
 

2. 기본 undotbs를 undotbs2로 변경
ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS2;

 

3. undotbs1 삭제
DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

 

4. undotbs1 재생성
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/oradata/undotbs01.dbf' SIZE 500M;

 

5. 기본 undotbs를 undotbs1로 변경
ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS1;

 

6. 임시 undotbs2 삭제
DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES;