RE: Moving LOB's from tablespace to tablespace

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
lyallbarbour@xxxxxxxxxxxxxxx
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?

 

Lyall

Other related posts: