Re: Can I "Compress" a tablespace?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 08 Sep 1999 18:46:55 +0800
Message-ID: <37D63E9F.2E6E@yahoo.com>

Bob wrote:
>
> In article <7r3spf$3k8$1_at_nnrp1.deja.com>,
> Ben Ryan <benryan_at_my-deja.com> wrote:
> > ALTER DATABASE DATAFILE '/directory/filename' RESIZE number M;
>
> Thank you very much, Ben.
>
> Bob
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Note that you can only resize a tablespace downwards if the space you are trying to reclaim has NEVER been used...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Sep 08 1999 - 05:46:55 CDT