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? > -- //www.freelists.org/webpage/oracle-l