重建undo和temp的方法

--UNDO
create  undo tablespace  UNDOTBS2  datafile '/arrayapp/oracle/oradata/newindb/temp.dbf'  size 50M reuse
ALTER SYSTEM SET undo_tablespace='UNDOTBS2' ;
drop tablespace UNDOTBS1
create UNDO tablespace UNDOTBS1 datafile  '/dev/vgdata4/rv4_rbs01' size 4159M;
ALTER SYSTEM SET undo_tablespace='UNDOTBS1' ;
drop  tablespace  UNDOTBS2 including contents and datafiles;

---temp

create temporary tablespace TEMP2 TEMPFILE '/arrayapp/oracle/oradata/newindb/temp.dbf' size 50M;
alter database default temporary tablespace temp2;
drop tablespace temp including contents and datafiles;
create temporary tablespace TEMP TEMPFILE '/dev/vgdata4/rv4_temp01' size 4159M;
alter database default temporary tablespace temp;
drop tablespace temp2 including contents and datafiles

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/598601/viewspace-608067/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/598601/viewspace-608067/