Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Zero Percent Free space
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