RE: Moving LOB's from tablespace to tablespace
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
March 7 - 11, 2010
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of lyallbarbour_at_sanfranmail.com
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?
LyallReceived on Tue Oct 27 2009 - 09:35:22 CDT