Question

  Asked: Jan 14 2008   7:42 PM GMT
  Asked by: DAC


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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
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)
  • AddThis Social Bookmark Button

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