| Req. help on Temporary Tablespace [message #177929] |
Sun, 18 June 2006 01:53  |
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
|
Senior Member |
|
|
Dear Friend/Sirs
I am working with oracle 9i on linux os.i had face problem of my temporary tablespace, Size of tempfile grows to limit of a partition(10GB) than no space left for new sort operation and my database remain hang.I have to delete the tempfile by OS command because i have to create new default temporary tablespace with tempfile .but now i can't delete the previouse temporary tablespace.now i set the maxsize of 1 gb for my new tempfile.
Is there anyway to shrink the tempfile or is there any way to find out faulty application by which my tempfile goes up.i'm not able to shrink my tempfile.
Please give me any solution u have or refer me some online sites so that i can understand much about temporary tablespace issues.
Hoping for the positive reply
Regards
Jimmy.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
