> It is temp Temp tablespace. > Can drop/recreate temp tablespace easily? > > It is a production system.
Create new temporary tablespace (with tempfiles, you're on 8i), assign it to your users (alter user <username> temporary tablespace <new_temp>), drop the old one.
Still curious to see the segments (name/type) in the old one :)
