Re: Can datafile be resized while instance is open?

From: Dean <dh6864_at_gmail.com>
Date: Mon, 25 Apr 2011 14:50:53 -0700 (PDT)
Message-ID: <4dac2ade-5408-41dd-a97d-eab9bb78a3eb_at_r35g2000prj.googlegroups.com>

On Apr 15, 7:04 pm, Noons <wizofo..._at_yahoo.com.au> wrote:
> Mladen Gogala wrote,on my timestamp of 16/04/2011 3:24 AM:
>
> > On Fri, 15 Apr 2011 09:48:45 -0700, Dean wrote:
>
> >> Hi, I am a newbie administrator.  Is it safe to alter datafile size
> >> while database is open?
>
> > And how would you do it with a closed instance?
>
> LOL!  Indeed...

Sorry guys. I probably used the wrong language. What I had in mind was
>lsnrctl stop
>sqlplus / as sysdba

but that doesn't mean the instance is not open, I guess. Thanks for bearing with me.
Dean Received on Mon Apr 25 2011 - 16:50:53 CDT