Re: resize datafile

From: David Sisk <davesisk_at_ipass.net>
Date: 1998/12/15
Message-ID: <t_jd2.1017$kx1.1552@news.ipass.net>#1/1

Hi Steve:

There is one bug you might want to know about. Prior to 7.3.4 (actually, I think it may be 7.3.3.6), you cannot re-create the control files if any of the datafiles have been resized in any manner (either through manually doing the ALTER....RESIZE or setting the datafile to autoextend up to some number). Support says this is fixed in 7.3.4, though I have not yet tested it.

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm


steve_young_at_my-dejanews.com wrote in message
<753tk9$j72$1_at_nnrp1.dejanews.com>...


>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 Tue Dec 15 1998 - 00:00:00 CST