Re: Can datafile be resized while instance is open?
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Fri, 15 Apr 2011 16:27:25 -0700 (PDT)
Message-ID: <6563b563-2961-4aad-b1eb-a6fb217becad_at_p3g2000vbv.googlegroups.com>
On Apr 15, 12:48 pm, Dean <dh6..._at_gmail.com> 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
Date: Fri, 15 Apr 2011 16:27:25 -0700 (PDT)
Message-ID: <6563b563-2961-4aad-b1eb-a6fb217becad_at_p3g2000vbv.googlegroups.com>
On Apr 15, 12:48 pm, Dean <dh6..._at_gmail.com> 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