RE: Moving LOB's from tablespace to tablespace

From: Ric Van Dyke <>
Date: Tue, 27 Oct 2009 09:35:22 -0500
Message-ID: <>

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


Hotsos Symposium

March 7 - 11, 2010

Be there.    

[] On Behalf Of
Sent: Tuesday, October 27, 2009 9:44 AM
Subject: Moving LOB's from tablespace to tablespace  

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?  


Received on Tue Oct 27 2009 - 09:35:22 CDT

Original text of this message