A question about temp tablespace. We are on 8.1.7.2.
I ran the following query and it came back with TEMPORARY.
select contents from dba_tablespaces where tablespace_name='TEMP2';
Should this be temporary or permanent? Thanks.
Printable View
A question about temp tablespace. We are on 8.1.7.2.
I ran the following query and it came back with TEMPORARY.
select contents from dba_tablespaces where tablespace_name='TEMP2';
Should this be temporary or permanent? Thanks.
Temporary.
I thought temporary tablespace designated as such for users, should be permanent. How would the temporary segments be released after a sort completes?
Personally, pre 9i I kept all my TEMP tablespace of type Permanant.
Yes they(default tablespace) should be permanent, but if you create them as temporary tablespace then what can be done. Assign a temporary tablespace as users temporary tablespace so that temporary segments are release after sort operation finishes.Quote:
Originally posted by pcotten
I thought temporary tablespace designated as such for users, should be permanent. How would the temporary segments be released after a sort completes?
Any particular reasons for that? I can't see any? But I can certanly see reasons against this....Quote:
Originally posted by grjohnson
Personally, pre 9i I kept all my TEMP tablespace of type Permanant.