Re: Q: Using less space for XE install?
From: joel garry <joel-garry_at_home.com>
Date: Tue, 16 Jun 2009 15:25:18 -0700 (PDT)
Message-ID: <fff4bf2e-7e4b-4ff5-bc70-b1c65f2a9c59_at_t16g2000yqi.googlegroups.com>
On Jun 16, 2:49 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Jun 16, 5:39 pm, joel garry <joel-ga..._at_home.com> 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.
Date: Tue, 16 Jun 2009 15:25:18 -0700 (PDT)
Message-ID: <fff4bf2e-7e4b-4ff5-bc70-b1c65f2a9c59_at_t16g2000yqi.googlegroups.com>
On Jun 16, 2:49 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Jun 16, 5:39 pm, joel garry <joel-ga..._at_home.com> 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.
jg
-- _at_home.com 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