[Tip] UNDO Full 발생 시

CREATE  UNDO TABLESPACE "UNDOTBS2" DATAFILE '/oradata/undotbs02.dbf' SIZE 10M;   
- undotbs02번 생성

 
ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS2; 
- 기본 undo 테이블을 unodtbs2로 변경

DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;
- undotbs1 테이블 삭제

CREATE  UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oradata/undotbs01.dbf' SIZE 500M;
- undotbs01번 생성

ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS1;
- 기본 undo 테이블을 unodtbs1로 변경

DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES; 
- undotbs2 테이블 삭제