DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2000


    Just wanted to know what is the use of temporary table space?
    Last night I uploaded a 50 Meg file and this morning when I checked I noticed that my temp, system and dbname tablespaces are used upto 98%?
    I understand that my dbname tablespace needs to be resized to something bigger but why have my system and temp datafiles reached to 98%? Shouldnt temp usually be empty when no processing is going on? And what do I do with the system datafile? Do I need to increase the size of that datafile(tablespace) too, since it is occupying 98% of the allocated space?

  2. #2
    Join Date
    Feb 2000
    Washington DC
    You better delete this thread. you got answers for your Q's already in the DBAdmin discussion group.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.