Re: Resizing a Datafile

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Sat, 19 Dec 98 09:59:29 +0200
Message-ID: <ACXprUsK42@protasov.kiev.ua>

Hi,

Database must be opened to perform this operation.

Andrew Protasov

> 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
>
>
Received on Sat Dec 19 1998 - 01:59:29 CST