Re: Extent sizes

On Sun, 25 Sep 2005 19:00:32 -0700, PK wrote:

>
> Jonathan,
> That explains it very well.
> The level 1 bitmap that covers the present and the next extents - is it
> normal for all locally managed tablespaces ?

Yes. Locally managed tablespaces use bitmaps instead of dictionary tables like uet$. If you want to inspect blocks within your table, you can do the following:

ALTER SYSTEM DUMP DATAFILE file# BLOCK MIN min_block# BLOCK MAX max_block#;

The priceless site for learning everything about the dumps that a dumpster can possibly need is http://www.juliandyke.com That is how you can find out about the blocks in your database. Happy dumping!

-- 
http://www.mgogala.com