Re: Can datafile be resized while instance is open?
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Fri, 15 Apr 2011 16:30:24 -0700 (PDT)
Message-ID: <237fdeef-fe4f-42f8-8651-9c5e68c71197_at_w6g2000vbo.googlegroups.com>
Dean:
Date: Fri, 15 Apr 2011 16:30:24 -0700 (PDT)
Message-ID: <237fdeef-fe4f-42f8-8651-9c5e68c71197_at_w6g2000vbo.googlegroups.com>
Dean:
# Hi, I am a newbie administrator.
Hey Dean I am an old grumpy DBA.
Sure you can "probably" safely grow and resize datafiles while the database is up especially with more recent versions of Oracle.
# If not, what would be the proper procedures to take before executing
the alter sqls?
Do you have backups in place? Do you have a tried and proven recovery strategy?
While you are learning and trying things first point is to do your learning and experimenting on a test system. Received on Fri Apr 15 2011 - 18:30:24 CDT