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: Defragmenting System

Re: Defragmenting System

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 03 Jun 1999 11:45:58 -0700
Message-ID: <3756CD66.D4D49FE@us.oracle.com>


Stephen

There's no problem with defragmenting the SYSTEM tablespace, other than the fact that it's a complete database rebuild that's necessary to do it (you can't take the SYSTEM tablespace offline, so it can't be defragmented in the normal tablespace defragmentation method).

HTH. Pete

kumite23_at_my-deja.com wrote:

> Because of some band-aids, I now have three !!!
> system datafiles allocated to the system
> tablespace. I would like to extend one of them
> and get rid of the other two to make maintenance
> simpler and less fragmented. I have read you
> should not defragment the system tablespace (or
> the user SYS). Does anyone have information to
> help me>?
>
> Thanks,
>
> Stephen
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--

Regards

Pete


Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)
Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA



Received on Thu Jun 03 1999 - 13:45:58 CDT

Original text of this message

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