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: Table/Index Reorg tool?

Re: Table/Index Reorg tool?

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Tue, 27 Jul 1999 10:34:10 +0100
Message-ID: <933068076.14548.0.nnrp-14.c2de6f3d@news.demon.co.uk>


To do a reorg, the data must be taken offline, so no, there is no reorg tool that I know off that could allow you to reorg and have the data available. I'd be interested to hear otherwise.

There are fast reorg tools available, we use Platinum TSReorg with the fast Unload option. V.Fast but it still requires downtime.

Rajeev R Sharan wrote in message <379D1A95.86EFED6D_at_stny.lrun.com>...
>Hello,
>We're running SAP on Oracle and system is expected to be up 24x7. Is
>there any tool out there which could assist me in doing a reorg without
>effecting the SAP application?
>Thanks in advance.
>- Rajeev
>
Received on Tue Jul 27 1999 - 04:34:10 CDT

Original text of this message

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