RE: Moving LOB's from tablespace to tablespace
From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Tue, 27 Oct 2009 09:35:22 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF015C3B90_at_WIN02.hotsos.com>
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.
Date: Tue, 27 Oct 2009 09:35:22 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF015C3B90_at_WIN02.hotsos.com>
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
lyallbarbour_at_sanfranmail.com
Sent: Tuesday, October 27, 2009 9:44 AM
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 27 2009 - 09:35:22 CDT