Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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..."Received on Tue May 21 2002 - 13:57:05 CDT