joel garry wrote:
> wyys.cn_at_gmail.com wrote:
>> cause advance replication doesn't work. a lot of data segment locate
>> in sytem tablespace, so system tablespace space is much beeter than
>> before, any ways to release system tablespace space? thanks in advance!
>
> You can only shrink a tablespace as far as there isn't any data. You
> can find a script or use OEM tablespace map (on some versions) to see
> where the data ends in the tablespace. There are more advanced things
> one can do, but you want a good DBA in there if you are messing with
> system. If your database isn't too big, it might even be worthwhile to
> recreate it from scratch, especially if it has been migrated from DMT
> to LMT.
>
> There is some dependence on version and platform.
>
> jg
Look at the dbms_space built-in package. It has two procedures
for identifying shrink candidates which may help with shrinking
some segments.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 01 2006 - 18:13:24 CDT
