Re: Q: Using less space for XE install?

From: joel garry <>
Date: Tue, 16 Jun 2009 15:25:18 -0700 (PDT)
Message-ID: <>

On Jun 16, 2:49 pm, John Hurley <> wrote:
> On Jun 16, 5:39 pm, joel garry <> wrote:
> snip
> > 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.

's Hurley, ur Joe King.

To be honest, rather than actually remember the syntax or look it up, I went into dbconsole, administration, tablespace, then did show sql from the resize screen. But it's ok, I remember when shrinking could corrupt things.


-- is bogus.
"lakers fans 1) congrats 2) riot 3) f you! " - tweet from producer of
Kevin & Bean show.
Received on Tue Jun 16 2009 - 17:25:18 CDT

Original text of this message