Morphing extents

From: Anne Hanson <anneh1_at_my-deja.com>
Date: Tue, 23 Nov 1999 20:56:02 GMT
Message-ID: <81ev10$g1s$1@nnrp1.deja.com>

Perhaps this is an easy question, but it's stumping me...

I have dropped and recreated table BLAH in a tablespace where the default initial_extent and next_extent sizes are both 131072 bytes, and pct_increase = 0. However, when I query the dba_extents table for info on BLAH, it shows all of the extents are *133120* bytes, ie each extent is exactly 1 block larger than the desired size. Queries of dba_segments and dba_tables both show that initial_extent and next_extent theoretically are 131072 bytes.

Does anyone know what is going on here? Thanks for any help.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 23 1999 - 14:56:02 CST