Re: how to release system tablespace space?

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

-- 
@home.com is bogus.
http://www.scarysquirrel.org/page1.html