| Azaz |
Posted: Apr 30, 2008 05:23:06 AM |
Total Post: 44
Joined: Mar, 2008
|
| Can someone help me, on how to empty contents of temp tablespace |
|
|
 Azaz |
| Posted: Apr 30, 2008 05:32:21 AM |  |
|
Total Post: 44
Joined: Mar, 2008
|
I want to flush the contents of temp tablespace in Oracle 9i.
Can someone tell or help me on this
|
|
|
|
|
| Murtuja |
| Posted: Apr 30, 2008 05:50:48 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
You don't have any control over Temporary Tablespace.You can just recreat Temporary Tablespace.
See this link.
http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_3.shtml
|
|
|
|
|
| GOPU |
| Posted: Apr 30, 2008 06:13:57 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
I dont think any command is there to flush the temporary tablespace.
but you can do one thing to flush the temp tablespace...
Create a new temporary tablespace may be of smal size (with the different
name ) in the database and alter all users to use that temporary tablespace.Then drop and recreate the earlier temporary tablesapace and again alter allthe users back to use temporary tablespace. It will flush all the data .
|
|
|
|
|
| Gitesh |
| Posted: Apr 30, 2008 07:49:55 AM | |
|
Total Post: 322
Joined: May, 2005
|
Just shut down your database and restart it. Temporary segment always drop when database shutdown.There is another way to drop temporary segment from temporary tablespace but it is risky.
|
|
|
|
|
| Mohammed Taj |
| Posted: May 01, 2008 02:04:05 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
>>>Just shut down your database and restart it.
But why ?
Who care about temporary tablespace...is it not efficient to just recreate new TEMP tablespace with TEMPFILE.
|
|
|
|
|
| Gitesh |
| Posted: May 01, 2008 11:13:42 PM | |
|
Total Post: 322
Joined: May, 2005
|
Temporary tablespace is for sorting operation. Do you think it is useless?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
