recreate undo tbs.sql

来自「Oracle培训专题3-数据库配置.ppt Oracle培训专题4-备份和恢复」· SQL 代码 · 共 26 行

--Create new undo tablespace
CREATE UNDO 
	 TABLESPACE "UNDOTEMP" 
	 DATAFILE 'D:\ORACLE\ORADATA\MY9IDB\UNDOTEMP.ora'
	 SIZE 200M;
   
   
Alter System Set UNDO_TABLESPACE='UNDOTEMP' scope=both;

ALTER TABLESPACE UNDOTBS1 OFFLINE;

DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS;



CREATE UNDO TABLESPACE "UNDOTBS1" 
 DATAFILE 'D:\ORACLE\ORADATA\MY9IDB\UNDOTBS1.ora'
 SIZE 200M
 [reuse]

ALTER SYSTEM SET UNDO_TABLESPACE='UNDOTBS1' SCOPE=BOTH   

ALTER TABLESPACE UNDOTEMP OFFLINE


SELECT usn,xacts,rssize/1024/1024 as rssize,hwmsize/1024/1024 as hwmsize FROM V$ROLLSTAT order by rssize