Re: resize datafile

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Mon, 14 Dec 98 23:54:56 +0200
Message-ID: <ABmaOTsK42@protasov.kiev.ua>

Hi,

There are no problems with this. Oracle is smart enough to recognize this situation:

SVRMGR> alter database datafile 'h:\orabase\prot1.ora' resize 20m; alter database datafile 'h:\orabase\prot1.ora' resize 20m *
ORA-03297: file contains 19907 blocks of data beyond requested RESIZE value

You will not damage your data.

Andrew Protasov

> If I want to resize a datafile, do I need to shutdown the server or dismount
> the instance? If I reduce the size of a datafile from 2GB to 1GB but the
> datafile currently have more than 1GB data, will it be possible or will it
> damage the data?
>
> thanx.
>
> Steve
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
Received on Mon Dec 14 1998 - 15:54:56 CST