Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Lost Table Space

Re: Lost Table Space

From: Darren Brock <brock_at_governet.net>
Date: Thu, 21 Oct 1999 11:03:40 -0600
Message-ID: <380F476C.6CA7B7AC@governet.net>


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 - 12:03:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US