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: Online creation/extension of Tablespaces possible??

Re: Online creation/extension of Tablespaces possible??

From: Steve <ThisOne_at_Aint.valid>
Date: Sat, 11 Sep 2004 22:15:44 +1200
Message-ID: <chuj8g$1ri$1@lust.ihug.co.nz>


qazmlp wrote:
> We have a requirement for increasing the size of the existing
> Tablespaces. In my understanding, this could be done in either of the
> following ways:
> 1.adding one more datafile to the tablespace
> 2.resize the datafile to a high value
> 3.autoextend ON for system datafile
>
> I would like to know whether the above operation i.e increasing
> Tablespace size through one of the above ways, can be done online(DB
> is running and Application also is using DB)?
>
> What about the case of creating new Tablespace? Can it be done
> online(on any HW model where Oracle is used)?
>
> Thanks!

Yes.

Steve Received on Sat Sep 11 2004 - 05:15:44 CDT

Original text of this message

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