What is temp01.dbf file?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: What is temp01.dbf file?

  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