Re: Availability of table or index while moving to a different tablespace

You can rebuild the indexes online (using alter index rebuild online) but if you move the table, the indexes will become unusable and the table wil not be queryable. If there is no DML being done against that table, you can do the following:
create table B as select * from A
create indexes on the table you just created rename A to A-old
rename B to A
if there is DML going on, Quest Software supposedly has a tool that will let you move tables online even if there is DML being done to them. In article <CSDU5.29692$L26.8358599_at_typhoon.southeast.rr.com>,   "Cory Brooks" <coryb_at_nc.rr.com> wrote:
> Does anyone know how moving either a table (via alter table move
 tablspace)
> or an index (via alter index rebuild) affects availability of the
 data or
> index during the move? I'm looking at moving some large tables and
 their
> indexes into separate tablespaces but do not want to make the data
> unavailable during the move.
> Thanks in advance.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 28 2000 - 10:17:17 CST