 Urgent - Need to manually shrink Temporary Space [message #110983] |
Fri, 11 March 2005 11:53  |
hueymoo
Messages: 3
Registered: March 2005
Location: Goderich, ON
|
Junior Member |
|
|
I have a huge temporary tablespace (no one has been monitoring it) and it has caused my disk to fill up. I want to shrink it and the corresponding datafile, but this is my only temporary tablespace and is, of course, the default.
What is the best way to do this.
Thanks,
Darlene
|
|
|
|
|
|
|
|
|
|
| Re: Urgent - Need to manually shrink Temporary Space [message #111129 is a reply to message #110983] |
Mon, 14 March 2005 02:03  |
easywebtech123
Messages: 22
Registered: March 2005
Location: c
|
Junior Member |
|
|
I had the same issue. Pls. keep in mind following things.
temporary tablespace use to store temporary data when you run sqls.
So after db restart, there should not be data in the temp table space.
But it can't reduce the datafile size after expand.
So you have to run below command manualy to reduce it.You can reduce what ever you need, but again it will increase depend on the sqls you run.
alter database datafile 'D:\ORACLE\ORADATA\....\TEMP01.DBF' resize 514M;
webmaster
http://www.easywebtech.com
|
|
|
|
| Re: Urgent - Need to manually shrink Temporary Space [message #111175 is a reply to message #110983] |
Mon, 14 March 2005 08:19 |
hueymoo
Messages: 3
Registered: March 2005
Location: Goderich, ON
|
Junior Member |
|
|
Thanks to both of you for your advice.
I was able to recreate my temp space to 500MB and this morning, after a full weekend of loads, it is still sitting at only 10% of it's capacity. We still need to track down how it got so big in the first place, but for now we are at least able to operate.
Thanks again,
Darlene
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
