Re: cannot resize a tablespace

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 17 Sep 1999 22:33:32 +0800
Message-ID: <37E2513C.6815@yahoo.com>

Jorge wrote:
>
> I deallocate unused space of all tables but I cannot downsize datafile under
> lowest currently used block, but I have a datafile too much bigger, so, How
> can I defrag it or set the lowest currently used block acording to my amount
> of data???

Use dba_extents to determine the segment that is using this high point in the tablespace...recreate it (or drop it) and then resize

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 Fri Sep 17 1999 - 09:33:32 CDT