Re: Lost Table Space

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 21 Oct 1999 13:06:19 -0400
Message-ID: <7unh2c$edo$1@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 - 12:06:19 CDT