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

Home -> Community -> Usenet -> c.d.o.server -> Re: Zero Percent Free space

Re: Zero Percent Free space

From: Anurag Minocha <anurag_at_synergy-infotech.com>
Date: Sun, 27 Jun 1999 12:52:14 +0530
Message-ID: <3775D125.4F88E90B@synergy-infotech.com>


Thanks a lot for your help

anurag

Tarun Agarwal wrote:

> Anurag Minocha wrote:
>
> > Hi ,
> >
> > My Rollback and system tablespace have zero percent free space . what
> > should i do .how should i tacke this. I am a newbee so please help me
> > out with this.
> >
> > thanks in advance
> >
> > anurag
> >
> > reply to
> > anurag_at_synergy-infotech.com
>
> Rollback segments will utilize the space again as they are reused.
> For system tablespace add another datafile using the command
>
> alter tablespace add datafile 'path of datafile' size nnM;
Received on Sun Jun 27 1999 - 02:22:14 CDT

Original text of this message

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