Re: Reorganizing SYSTEM tablespace

From: A.Liggins <A.Liggins_at_hotmail.com>
Date: Wed, 22 May 2002 18:09:52 +0000 (UTC)
Message-ID: <acgmtf$s09$1@knossos.btinternet.com>

What exactly are the extents at the end of the file that belong to sys?

Doc ID: Note:166301.1 ---->
If they are AUD$ you can truncate the file (export it first) - its for auditing. Anything else then...No.

Alun

"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 Wed May 22 2002 - 13:09:52 CDT