Re: Lost Table Space

From: Edwin Esser <eesser_at_hetnet.nl>
Date: Thu, 21 Oct 1999 23:00:11 +0200
Message-ID: <OXS9eYAH$GA.288@net025s>

When Oracle creates an object (in this case a new table), it first needs that size as consecutive file space. You propbably have a fragmented tablespace.

Edwin

"KM" <skmok_at_worldnet.att.net> wrote in message news: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 - 16:00:11 CDT