Re: Info wanted: On-line reorg tool

From: Connor McDonald <>
Date: Fri, 08 Mar 2002 22:04:53 +0000
Message-ID: <>

Vince Laurent wrote:
> I am looking at three tools:
> TSreorg from Computer Associates
> Space Expert from BMC
> Space manager from Quest
> We are running Oracle 8.1.x and SAP. Anyone have any experience with
> any of these? Any comments? Any suggestions as to what to ask vendors
> of database reorg tools? We are a 24x7 shop (hospitals) so downtime
> is VERY hard to get. One of the requirements is a on-line tool.
> Thanks for any information!
> Vince

Indexes can be rebuilt online which leaves just tables (which will be possible in 9i). Under most conditions, good choice of pctused/pctfree can avoid most table reorg requirements.


Connor McDonald

"Some days you're the pigeon, some days you're the statue..."
Received on Fri Mar 08 2002 - 23:04:53 CET

Original text of this message