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: Resizing a Datafile

Re: Resizing a Datafile

From: <tedchyn_at_yahoo.com>
Date: Sat, 19 Dec 1998 20:34:41 GMT
Message-ID: <75h2l1$jcl$1@nnrp1.dejanews.com>


You don't. If you do you can not execute the command.

Ted Chyn(certified oracle dba)

In article <367b496d.19213848_at_news.localnet.com>,   scottrp_at_localnet.com (Scott) wrote:
> Hello -
>
> I am pretty new at Oracle - We have Oracle 7 running on SCO Unix. I
> would like to know if you have to bring the database down to manually
> resize a datafile (or can I just keep everything running) ?
>
> I was planning on using:
>
> ALTER DATABASE DATAFILE 'file1.dbf'
> RESIZE 15M;
>
> Thank You for your help !
>
> scottrp_at_localnet.com
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Dec 19 1998 - 14:34:41 CST

Original text of this message

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