Re: Moving LOB's from tablespace to tablespace

Thanks for the replies everyone.  I rebuilt the indexes and understand the 
ALTER TABLE command for moving objects around a bit more now.
Cheers,
Lyall


-----Original Message-----
From: Rodd Holman <rodd.holman@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Tue, Oct 27, 2009 11:04 am
Subject: Re: Moving LOB's from tablespace to tablespace


Add the "update indexes" statement to the end of your alter table move command 
and Oracle will automatically fix the unusable indexes. I do this all the time 
works like a charm. It adds some time to your move command, but you're going to 
spend that time manually rebuilding the indexes anyway,. 
 
--Rodd 
Ric Van Dyke wrote: 
> 
> That seems expected to me, you just MOVED all the data, the indexes > will 
> have to be rebuild to point at the new location of all the LOBs. > 
> ----------------------- 
> 
> Ric Van Dyke 
> 
> Hotsos Enterprises 
> 
> ----------------------- 
> 
> *From:* oracle-l-bounce@xxxxxxxxxxxxx > 
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of > 
> *lyallbarbour@xxxxxxxxxxxxxxx 
> ** > 
> So, i had to move some LOB's from tablespace to different tablespace > using 
> the ALTER TABLE command. Thing is, after i did this, a bunch of > indexes 
> became UNUSABLE. Also, these indexes weren't on the LOB's... > Anyone know 
> what i did wrong? Or what happened? 
> 
-- 
http://www.freelists.org/webpage/oracle-l

Other related posts: