How many physical datafiles have you created in this tablespace and what
size?
Regards
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 - 06:43:08 CDT
