Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Resizing a Datafile
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