DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Removing Temporary segment!

  1. 12-21-2001, 09:07 AM #1
    nansbrain
    nansbrain is offline Junior Member
    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


    Reply With Quote Reply With Quote
  2. 12-21-2001, 09:21 AM #2
    julian
    julian is offline Senior Advisor
    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.




    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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