原贴地址:http://community.csdn.net/Expert/topic/5776/5776795.xml?temp=.4839594
修改缺省temp表空间方法:
create temporary tablespace temptest tempfile '/dev/vgqrya01/rlv_08_temp_002';
alter database default temporary tablespace temptest;
drop tablespace temp;
create temporary tablespace temp tempfile '/dev/vgqrya01/rlv_08_temp_001';
alter database default temporary tablespace temp;
drop tablespace temptest;