-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|