Hi all,

I am migrating from 8i to 10g. I need to get the most out of the space in each datafile. I know space is cheap. But, we are paying someone to host the storage for us and do want to waste any space, it is expensive.

Let starts with a small example:

CREATE TABLESPACE lmtsmall DATAFILE '/u02/oracle/data/lmtsmall01.dbf' SIZE 5120k
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128k
SEGMENT SPACE MANAGEMENT AUTO;

How much space do I need to add for the extent bitmap, so I use all the space in the file? Right now I should get 40 extents, but what about the bitmap?

Thanks,
Kathy