I have an Oracle 10g database with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but it's had no effect.
Oracle does not automatically remove the temp segments in the temp tablespace. However, the temp segments may be empty of temporary data. Oracle allocates the temp segment for a user needing temp space. When the user no longer needs temp space, Oracle will reuse that temp space in the segment for another user's request. So just because your temp tablespace looks full does not mean that anything is wrong. You will, however, need a temp tablespace large enough to hold all temp segment requests
Dig Deeper on Oracle database administration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.