-
If I have a tablespace with one table with a next extent of 5M and I add a datafile of 100M to the tablespace. Would that mean that there would be 20 available extents to that tablespace? Would there be any other factors that would fragment that tablespace and reduce the amount of available extents?
-
it depends how you have created your tablespace, LMT or DMT
if it´s LMT and you use uniform size clause of 5MB then you will have 20 5MB extents
if it´s DMT you will have two extents in that new datafile, one 5MB and the other 95MB
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
|