Re: datafile resize ?

From: Sheilah Scheurich <scheuric_at_sprynet.com>
Date: 1997/07/26
Message-ID: <01bc99fa$b9ba4f80$c7c0afce@SPRY02SPRY262498>#1/1

It is an effortless process and works wonderfully in an HPUX environment. I'm not sure if there were active transactions in the tablespace at the time of the resize.

-Sheilah Scheurich
DBA

-- 
These opinions are my own and not
not of my employer.



Wang ZhenXi <chong01_at_singnet.com.sg> wrote in article
<01bc977c$3dd77300$6aa215a5_at_apple>...


> Hi,

> 

>    Have anybody tried resizing the datafile while

>    it is online in a production environment ?

>    Is it safe to do it while there are transactions

>    taking place on the tables in the datafile ?

>    

>    e.g.

>     alter database datafile '/dsk1/test.dbf' 600M;

> 

>    Thanks

> 

> 

>

Received on Sat Jul 26 1997 - 00:00:00 CDT