Hello: I am running oracle 9.2.0.8. I just finished recreating a temp tablespace. I have created a new tablespace and then issued alter database default tablespace temp02 command. I think it is safe now to drop my old tablespace. I checked that all users have temporary TS set to TEMP02. Do I need to check anything else before removing my old temp TS? thank you -- //www.freelists.org/webpage/oracle-l