Q
Problem solve Get help with specific problems with your technologies, process and projects.

Cleaning a temporary tablespace

A SearchOracle.com member asks, "I have an Oracle 10g database with its temporary tablespace full. Is there any way to clean this tablespace?"

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close