Re: Live Reorganize from SQL-script?
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 30 Apr 2005 06:56:17 -0700
Message-ID: <1114869148.725762_at_yasure>
> without taking it offline,
> i.e. clients can continue to update and select
> from the table, while the reorg is running.
>
> Is it possible to do the same thing from an SQL-script?
> If so, what are the commands for a live reorg?
>
> ---------------------------------------------- grz01
Date: Sat, 30 Apr 2005 06:56:17 -0700
Message-ID: <1114869148.725762_at_yasure>
grz01_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.
>
> Is it possible to do the same thing from an SQL-script?
> If so, what are the commands for a live reorg?
>
> ---------------------------------------------- grz01
Depends on what you want to do.
Take a look at the various ALTER TABLESPACE, ALTER TABLE
and ALTER INDEX options at http://tahiti.oracle.com and
the demos at http://www.psoug.org
click on Morgan's Library
click on Indexes
or click on Tables
or click on Tablespaces
or click on Data Files
or click on DBMS_REDEFINITION
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Apr 30 2005 - 15:56:17 CEST