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
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:
