How to refresh Temporary tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to refresh Temporary tablespace

  1. #1
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Hi

    My temporary tablespace is full. Now, no sorting is going on. Is it possible to refresh it.
    Thanks
    Kishore Kumar

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Are you sure?? There might be sorting perofrmed by Oracle itself, if not by any other user. The only way to clean out the temp ts is to bounce the db.

  3. #3
    Join Date
    Oct 2000
    Posts
    80
    Did you get some sort of error, or are you trying to free up disk space?
    If the latter, temporary tablespaces do not drop extents after they've been used for sorts, but hang on to them to save dynamic allocation overhead for later sorts. So the size of the tablespace will reflect the largest sort(s) you've done in there. The tablespace may show as being full, but it has space available for new sorts.
    You'd have to drop and recreate the TS to change storage parameters and datafile size.
    John Doyle

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Yes, it has shown could not extent by 126K ..... May be some of the user might have done big sort and may be it failed. However, that error occured yesterday.

    And the tablespace is full. However, now I am clear with it. Thanks
    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Oct 2000
    Posts
    80
    Is your temporary tablespace of temporary type? and is the datafile set to autoextend?
    Select contents from dba_tablespaces where tablespace_name='temp';
    John Doyle

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