Re: Reorganizing SYSTEM tablespace

Chuck wrote:
>
> 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

I had a similar problem (when someone wrote an endless-loop in a plsql code generator - several million objects later...)

A consultation with Oracle support was concluded with: "Take a backup, do it, and restore if it does not work". They did suggest doing as much as possible to avoid recursive txns (disable ddl triggers et al)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."