Re: Can datafile be resized while instance is open?

From: Luuk <Luuk_at_invalid.lan>
Date: Fri, 15 Apr 2011 19:26:19 +0200
Message-ID: <4da87fb8$0$41114$>

On 15-04-2011 18:48, Dean wrote:
> Hi, I am a newbie administrator. Is it safe to alter datafile size
> while database is open?
> I need to free up disk space of our database. I found scripts online
> to calculate high water mark of extents and resize the datafile
> accordingly.
> What I am not sure if I could execute sqls like "alter database
> datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DB05\TL30.dbf' resize
> 108m;" while database is online and open?
> If not, what would be the proper procedures to take before executing
> the alter sqls?
> Thanks,
> Dean

Received on Fri Apr 15 2011 - 12:26:19 CDT

Original text of this message