Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Defragmenting System
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
![]() |
![]() |