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

Home -> Community -> Usenet -> c.d.o.server -> Availability of table or index while moving to a different tablespace

Availability of table or index while moving to a different tablespace

From: Cory Brooks <coryb_at_nc.rr.com>
Date: Tue, 28 Nov 2000 01:28:02 GMT
Message-ID: <CSDU5.29692$L26.8358599@typhoon.southeast.rr.com> 






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.
Received on Mon Nov 27 2000 - 19:28:02 CST












Original text of this message













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