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: Help: SYSTEM Tablespace Fragmentation

Re: Help: SYSTEM Tablespace Fragmentation

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: Tue, 21 Jul 1998 12:48:45 -0600
Message-ID: <35b4e1ee.0@news.cadvision.com>


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

Original text of this message

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