Re: Locally Managed Tablespaces - can I view the bitmap ?

You can do a block dump of file header blocks (1st 64K) see my website for a note on dumping Oracle 8 blocks.

There are also a couple of X$ objects which interpret and display the bitmap blocks - the one you want is x$ktfbfe - which is used in views like dba_free_space

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Scott W wrote in message ...


>I am investigating the use of Locally Managed Tablespaces, ans was

 wondering


>if there is any way to view the bitmap to see what is going on.  I know

 with


>DD managed tablespaces, you can get an idea of growth by looking at UET$

 and


>FET$, but how are you supposed to look at this with a Locally Managed

>Tablespace ?  Maybe you're not...

>

>