RE: Moving LOB's from tablespace to tablespace

  • From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
  • To: <lyallbarbour@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 27 Oct 2009 09:35:22 -0500

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.




From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Sent: Tuesday, October 27, 2009 9:44 AM
To: oracle-l@xxxxxxxxxxxxx
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?



Other related posts: