I need to create tablespace dedicated to a table.
The table has INITIAL and NEXT extent sizes 512M.
And it is 30G in size.
So, the tablespace needs to have more than one datafile.
Even though, the next extent is 512M, I am seeing extensts of different sizes getting allocated to this table from dba_extents table. The extent sizes are anywhere between exact 512M to 512.03, 512.06, 512.12. There doesn't seem to be any logic !!
So, if I want every datafile to hold 4 extents, what should be the datafile size ? And why the extent sizes are different ?
Click Here to Expand Forum to Full Width