Re: Live Reorganize from SQL-script?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 01 May 2005 10:42:28 -0700
Message-ID: <1114969123.269624@yasure>

Matthias Hoys wrote:

> "Brian" <brian_at_databaseknowledge.com> wrote in message
> news:1114895481.554246.306340_at_g14g2000cwa.googlegroups.com...
>

>>In 92R2 and 10g you reorg tables online using DBMS_REDEFINITION.  This
>>works really well, I'ved used it a lot.  Clients are able to
>>ins/upd/del during the reorg process, however if you can turn off any

>
> atch type of operations you should.
>

>>see:
>>http://www.lc.leidenuniv.nl/awcourse/oracle/appdev.920/a96612/d_redefi.htm
>>

>
>
> Why do you need to reorganize tables in 9i/10g ? There's hardly any
> fragmentation with locally managed tablespaces.
>
> Matthias

DBMS_REDEFINITION has nothing to do with fragmentation.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sun May 01 2005 - 12:42:28 CDT