Re: Lost Table Space

From: Darren Brock <brock_at_governet.net>
Date: Fri, 22 Oct 1999 03:00:16 GMT
Message-ID: <6EC14873F507D3119B8C0090273C43490BED66@jdasoftware.com>

You may also want to check to see if you have reached the max extents specified. Coalesce is how you 'defrag' a tablespace if I remember correctly.

Darren

> > > 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 - 22:00:16 CDT