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$e4fe514c_at_news.xs4all.nl>
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
Date: Fri, 15 Apr 2011 19:26:19 +0200
Message-ID: <4da87fb8$0$41114$e4fe514c_at_news.xs4all.nl>
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
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dfiles003.htm#i1106377
-- LuukReceived on Fri Apr 15 2011 - 12:26:19 CDT