DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Tablespace Extent Question

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    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?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  


Click Here to Expand Forum to Full Width