Re: Info wanted: On-line reorg tool
Date: Tue, 12 Mar 2002 08:06:02 -0600
Message-ID: <052s8us405n71ucbm5um5c80v21kg44ftv_at_4ax.com>
Well, SAP currently only supports Oracle 8.1.7. 9i is under investigation and will probably be certified next year.
I didn't think anything could currently be rebuilt online since the application may be using the DB.
On Fri, 08 Mar 2002 22:04:53 +0000, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
>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.
>>
>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.
Received on Tue Mar 12 2002 - 15:06:02 CET