-
Temp tablespace file grew to 32GB
Hi!
I have Oracle 9i Standard server on Windows 2000 Server. I had Temp tablespace file grow to its limit of 32GB. Since the database had no other files in the tablespace I created another file for temporary solution.
The data in the database use about 8.6GB, and I am wondering what could cause such growth. If this is a query, is there a way to trace it? I am also looking for the best way to decrease the space of the database. My colleague proposes that I just drop the file and recreate it. Is that safe? Is there a way to just free up some space in the file and then shrink it?
Thanks.
Last edited by Fish; 11-21-2005 at 11:29 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|