If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Threaded View

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 ?