Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: SYSTEM Tablespace Fragmentation
I would rebuild the database. And then modify the sql.bsq file first to
change the storage parameters.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
nasof_at_hotmail.com wrote in message <6p2740$b1v$1_at_nnrp1.dejanews.com>...
>Does anyone have any advice on the best way to defrag SYS and SYSTEM
tables?
>Some tables have as many as 70 extents (and this is on a small hardly-used
>test Database!)
>
>-Frank
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jul 21 1998 - 13:48:45 CDT
![]() |
![]() |