重建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博客 ” ，链接：https://blog.itpub.net/598601/viewspace-608067/ ，如需转载，请注明出处，否则将追究法律责任。
