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: Adding new datafile question

Re: Adding new datafile question

From: <sybrandb_at_yahoo.com>
Date: 22 Dec 2003 02:40:35 -0800
Message-ID: <a1d154f4.0312220240.32b5513@posting.google.com>


ITAPORT06 <mokat67_at_hotmail.com> wrote in message news:<s34cuvgijvpbkh7ccjvhu0bipmepd0b94i_at_4ax.com>...
> Orcale 8i on WINNT
>
>
> I have a tablespace with one datafile (1) which has almost grown to
> 2080MB. I read on the forum that it is better not going over 200OMB
> so I will add a 2nd datafile to this tablespace.
>
> Datafile (1) has the following extend option: " autoextend on next
> 5120K"
>
> If I creating a 2nd datafile should I take away or put extend on
> datafile (1) on zero ?
>
> The goal is that that datafile (1) will not grow anymore and that the
> database starts to make use of datafile 2 for growth.
>
> Thanks

You'll need to set the maxsize attribute of datafile(1)

Hth

Sybrand Bakker
Senior Oracle DBA Received on Mon Dec 22 2003 - 04:40:35 CST

Original text of this message

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