-
TEMP tablespace
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.
-
Amar
"There is a difference between knowing the path and walking the path."
-
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.
OCP 8i, 9i DBA
Brisbane Australia
-
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?
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.
Amar
"There is a difference between knowing the path and walking the path."
-
Originally posted by grjohnson
Personally, pre 9i I kept all my TEMP tablespace of type Permanant.
Any particular reasons for that? I can't see any? But I can certanly see reasons against this....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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
|