Re: Lost Table Space

From: KM <skmok_at_worldnet.att.net>
Date: Thu, 21 Oct 1999 17:40:09 -0600
Message-ID: <7uo898$ja1$1@bgtnsc02.worldnet.att.net>

Is it the case that the space set for the "initial" parameter must be contigaous? That is, the table space may have 4 GB of fragmented space available, but not a contigaous chunk of 1GB for the new table?

What is the recommended way to defrag table space of such size (10 GB allocated)?

Thanks again!

Jerry Gitomer <jgitomer_at_hbsrx.com> wrote in message news:7unh2c$edo$1_at_autumn.news.rcn.net...
> Your problem appears to be not having a single free space of 1GB
> available. Since your posting indicates your are using 100MB
> extents for your other tables just make the initial and next
> extents for the new table 100MB.
>
> hth
> jerry gitomer
>
> KM wrote in message <7ul0na$elr$1_at_bgtnsc01.worldnet.att.net>...
> >I'm not a trained DBA, but have been asked a DBA question. Your
> help would
> >be much, much appreciated!
> >
> >We have allocated 10 GB of table space with 100 MG auto extents.
> We have
> >several tables that take up about 6 GB of space - we verified
> that by
> >looking at the space available using the DBA manager. However,
> when we
> >tried to create a new table, we cannot allocate a 1GB space for
> that table
> >out of this table space. Why? Anything to do we fragmented
> space in the 10
> >GB allocated?
> >
> >Thanks in advance!!!
> >
> >
>
>
Received on Thu Oct 21 1999 - 18:40:09 CDT