Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reorganizing SYSTEM tablespace

Re: Reorganizing SYSTEM tablespace

From: RSH <RSH_Oracle_NOSPAM_at_worldnet.att.net>
Date: Tue, 21 May 2002 19:07:30 GMT
Message-ID: <SVwG8.27660$D41.1043336@bgtnsc05-news.ops.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US