Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reorganizing SYSTEM tablespace
Connor, that sounds dreadful.
And of course, there are all the people that forget where PL/SQL and views
and such live.
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3CEA9881.30F_at_yahoo.com...
> 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 - 14:07:30 CDT