Can datafile be resized while instance is open?

#11

On Apr 15, 7:04*pm, Noons <wizofo... (AT) yahoo (DOT) com.au> wrote:

Quote:

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

Quote:

lsnrctl stop
sqlplus / as sysdba

but that doesn't mean the instance is not open, I guess.
Thanks for bearing with me.
Dean

#12

On Apr 15, 10:24*am, Mladen Gogala <n... (AT) email (DOT) here.invalid> wrote:

Quote:

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?

--http://mgogala.byethost5.com

What I was afraid of is that I am not sure what would happen
while I am altering the datafile and a user is writing data to that
datafile concurrently
when database is open for users to connect.
Sorry for the inappropriate term.
Dean

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Can datafile be resized while instance is open?

comp.databases.oracle.server comp.databases.oracle.server

Re: Can datafile be resized while instance is open? - 04-25-2011 , 04:50 PM

Re: Can datafile be resized while instance is open? - 04-25-2011 , 04:57 PM