Re: Live Reorganize from SQL-script?

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 1 May 2005 00:06:51 +0200
Message-ID: <4274017b$0$30475$ba620e4c@news.skynet.be>

"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 Received on Sat Apr 30 2005 - 17:06:51 CDT