Re: Live Reorganize from SQL-script?

From: Koki Sarmiento <kokisarmiento_at_yahoo.com>
Date: 30 Apr 2005 11:55:53 -0700
Message-ID: <1114887353.228615.128490@g14g2000cwa.googlegroups.com>

g..._at_spray.se wrote:
> >From OEM you can reorganize a table or tablespace,
> without taking it offline,
> i.e. clients can continue to update and select
> from the table, while the reorg is running.

What version of Oracle are you using?

> Is it possible to do the same thing from an SQL-script?

Yes.

> If so, what are the commands for a live reorg?

you can generate a list of commands from OEM.

Regards,
Koki Received on Sat Apr 30 2005 - 13:55:53 CDT