--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