Re: Can datafile be resized while instance is open?

From: John Hurley <>
Date: Fri, 15 Apr 2011 16:27:25 -0700 (PDT)
Message-ID: <>

On Apr 15, 12:48 pm, 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 - 18:27:25 CDT

Original text of this message