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_at_yahoo.com>
Date: Fri, 17 Sep 1999 22:33:32 +0800
Message-ID: <37E2513C.6815_at_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 - 16:33:32 CEST