Removing Temporary segment!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Removing Temporary segment!

  1. #1
    Join Date
    Jan 2001
    Posts
    23

    Hi All,

    I have the default temporary tablespace which is 99% full. It couldn't allocate more extents. Can you please suggest all possible ways to clear of the temp segments..

    I have read that Temporaray segments created are cleared or removed when the instance is restarted. But it doesn't seem to happen.

    Help please!!!

    Thanks is advance.

    Nandu



  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Drop it and recreate it like that:

    CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/vx/rdsk/datadg/disk26'
    SIZE 500M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

    Replace '/dev/vx/rdsk/datadg/disk26' with the file name you choose and if you think that 500M is not enough, set it to 2000M for example.





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