Re: Locally managed tablespaces

Hi Madhavan,

It is not correct to say that the locally managed tablespace takes 1 extent. It only takes 64K for the extent management bitmap. You would not have a problem if your datafiles were just 64K bigger. It is explained on my web site at http://www.ixora.com.au/tips/creation/datafiles.htm.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

On Mon, 19 Jun 2000 09:19:22 -0700, "Madhavan Amruthur " <mad5698_at_my-Deja.com> wrote:

>Hi all,
>We created our tablespaces as locally managed and we have about 4 tablespaces that are 40G. According to
>note 111666.1 on Metalink one extent from each datafile is used for storage management and we have 200M
>uniform extent size which means we lose 4G over a 40G tablespace with 20 data files. We have 4 tablespaces
>with 40G and that means 16G. We also have other tablespaces 20G.
>
>Is there a better way to do it other than converting it into a dict managed tbs with uniform extent size?
>
>Thanks for your help in advance.
>Regards,
>---
>Madhavan
>IBM Corporation
>Integrated Technology Services
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>Before you buy.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jun 20 2000 - 00:00:00 CDT