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.
Thanks is advance.
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.
Click Here to Expand Forum to Full Width