Temp Tablespace in 10G
Temp Tables, Oracle 10g
have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect Question
Temp Tables, Oracle 10g
have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Are you talking about the recycler? if so
purge recyclebin;
commit
Otherwise if the table is of no use to you, delete * from (TABLE in question)
Browse more Questions and Answers on SQL Server and Oracle.
Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Sap.sree | Jan 25 2008 3:26PM GMT
you can extend the temp tablespace if its size is very small or make it auto extend
