I'm not sure off hand, but I'm waiting for an email reply from the
originator of this problem. How does it matter, anyway? Thanks for your
enlightenment! - KM
Reza <reza_at_digital-dispatch.co.uk> wrote in message
news:940506452.17387.0.nnrp-04.d4f07aaa_at_news.demon.co.uk...
> 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 - 11:01:23 CDT
