| Help with growing temp tablespace [message #57655] |
Fri, 27 June 2003 06:53  |
Arpit
Messages: 99
Registered: March 2001
|
Member |
|
|
Hello,
For some reason my temp tablespace is growing full and we have left with very less disk space.
What sytax would i use to :
1. drop the temporary tablespace in adm instance and then manually delete the temp file. After that, recreate one.
2. downsize other datafiles
PLEASE HELP ME ASAP.
Thanks,
alpesh
|
|
|
|
| Re: Help with growing temp tablespace [message #57657 is a reply to message #57655] |
Fri, 27 June 2003 09:25  |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Questions:
Is your TEMP tablespace of type 'temporary' ? Coz if it is so, then after every recycle, the TEMP tablespace is initialized.
Or do this as 'system'
alter tablespace temp default storage (pctincrease 0);
The way you asked the question, looks like it is set to 'autoextend'. You can always keep a max size for that.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
