Re: How to shrink a tablespace?
From: Robert Pereira <robert_at_bytesize.ftech.co.uk>
Date: 1995/08/06
Message-ID: <403do9$8ln_at_mars.ftech.co.uk>#1/1
Date: 1995/08/06
Message-ID: <403do9$8ln_at_mars.ftech.co.uk>#1/1
When creating the smaller tablespaces, you're gona need to know
HOW SMALL
select tablespace_name, sum(bytes)
from sys.dba_extents
group by tablespace name;
should help
Robert
Received on Sun Aug 06 1995 - 00:00:00 CEST