locally manged tablespace

1. ser
Junior Member
Join Date
Apr 2003
Posts
46

## locally manged tablespace

hi

how would i change a locally managed permanent tablespace to a temporary tablespace.

i had another query , i was going through a book where i have db_block_size of 8kb, the size of third extent would be 12kb if initial is 8k, next is 8k , pctincrease is 50% and minextents is 3 , hence the total extent size would be 28kb
(8+8+12) but the ans that comes is 40kb as total size and third extent is 16k.how?

another question said if i had db_block_size of 4kb, and i create a tablespace with no default storage it assigns 5*db_block_size as initial and next, pctincrease is taken as 50% so what is the size of the third extent.
according to the book third extent would be 32kb. how?

thanks
Last edited by ser; 06-21-2003 at 01:24 AM.

2. Junior Member
Join Date
Jul 2001
Location
Slovenia
Posts
422
You say your db block size is 8k. So how many blocks should contain 12k extent? One and a half???
It gets rounded on next full block
I. 8k, 8k, 12k=>16k
II. 20K, 20K, 30k=>32k
Last edited by TomazZ; 06-21-2003 at 05:50 AM.

3. ## Re: locally manged tablespace

Originally posted by ser
hi

how would i change a locally managed permanent tablespace to a temporary tablespace.
Just create a new temporary tablespace and drop the permanent. That would be much simpler and quicker than posting that question.

4. ## Re: locally manged tablespace

Originally posted by ser
(8+8+12) but the ans that comes is 40kb as total size and third extent is 16k.how?
it will be 8+8+16 ( 8+4 = 12 rounded to 16 ) = 32, not 40k.

Join Date
May 2001
Posts
736
If iam right he got the question from sybex.There the guys added

8+8+16= 32 + 8block size so the total becomes 40k.But why they added the blocksize to the total there is no explanation.

6. Junior Member
Join Date
Jul 2001
Location
Slovenia
Posts
422
Ha, I missed that part of the question...
Because minimum initial size is 2*block_size.
so when you specify initial 8k next 8k pctincrease 50%, you get 3 extents as:
16k, 8k, 16k
sum 40k

7. Originally posted by TomazZ
Because minimum initial size is 2*block_size.

rechecked the manual, Min is 2*block_size if space management is manual & its 3*block_size if automatic...

Also, for every freelist group an extra block_size is needed.

so 2*block_size + 1*Number_Of_Freelists_group.

Abhay.

8. Senior Member
Join Date
Dec 2001
Location
Brazil
Posts
282
But why they added the blocksize to the total there is no explanation.
Maybe this block means the segment header block ... ?!

F.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•