Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Live Reorganize from SQL-script?

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@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 - 08:56:17 CDT

Original text of this message

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