Re: Q: Using less space for XE install?
Date: Tue, 16 Jun 2009 14:49:38 -0700 (PDT)
Message-ID: <c0535ec2-50d5-4bbe-a0f9-ac24933371b9_at_l12g2000yqo.googlegroups.com>
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. Received on Tue Jun 16 2009 - 16:49:38 CDT