Re: Reorganizing SYSTEM tablespace

Chuck, I'd like to get my hands on the "someone" first.

Rollbacks never belong in the SYSTEM tablespace except for the odd one or maybe two, over the years, that Oracle wants until RBS is set up.And then you take the SYSTEM segments offline, and drop any except for the first. And now we're back to REDO and similar terms...sigh. REDO and UNDO, who would have thought? If they want us to go back to ior -w to start a database...

SYSTEM (where most SYS and SYSTEM things live) is problematic. You might try to mark it for COALESCE using an ALTER or using OEM; it can't hurt to try. Oracle Dogma from its version of the Vatican still says don't ever run statistics on the SYS and SYSTEM schemas; I would not question that; it seemingly would lead to recursive optimization and other not good things.

You might be stuck with EXPORTing and IMPORTing your system. Which might not be an entirely bad thing, given the suspicion that your helper might have done other things you discover that you do not care for.

RSH. "Chuck" <chuckhNOSPAM_at_softhome.net> wrote in message news:ace34l$p1n6u$1_at_ID-85580.news.dfncis.de...
> Oracle 8.1.7.3.0
>
> Is it possible to reorg the system tablespace without recreating the
> database?
>
> I recently discovered that my system tablespace had grown from 100m to
1.6g
> because someone added 1.5g of rollback segments to it. I dropped the
> rollback segments but now want to shrink the file back down to 100m. The
> problem is that after the rollback segments got created, additional
extents
> were allocated at the end of the datafile. Is it possible to move those
> extents to the beginning of the free spaces in the file and then shrink
the
> file. Those extents belong to SYS objects.
>
> TIA
> --
> Chuck Hamilton
> To reply remove "_NOSPAM" from the address
>
>
Received on Tue May 21 2002 - 13:50:21 CDT