Re: Q: Using less space for XE install?

From: John Hurley <>
Date: Tue, 16 Jun 2009 14:49:38 -0700 (PDT)
Message-ID: <>

On Jun 16, 5:39 pm, joel garry <> wrote:


> These are all autoextensible, so will grow as you use them.  The
> general syntax for shrinking is alter database datafile
> 'fullypatheddatafilename' resize NNNM; where NNN is the size you
> want.  But if you have such space issues, you probably want to turn
> autoextend off, then things will run out of space at random times
> unless you watch things real close or turn on EM alerts.  To shrink a
> datafile, you can't go smaller than where data is actually in the
> datafile, and it is possible to have things near the end.  Oracle
> won't let you shrink if that would lose something.

Dang I was thinking that EM was the only way to change the size of something. Lean somethin nwe evrey day. Received on Tue Jun 16 2009 - 16:49:38 CDT

Original text of this message