Moving LOB's from tablespace to tablespace

From: <lyallbarbour_at_sanfranmail.com>
Date: Tue, 27 Oct 2009 09:43:38 -0400
Message-Id: <8CC25229F21CA35-11B4-324_at_web-mmc-d07.sysops.aol.com>

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

Received on Tue Oct 27 2009 - 08:43:38 CDT

This message: [ Message body ]
Next message: Johan Eriksson: "Upgrades with no downtime"
Previous message: Kumar Madduri: "apex workspace issue"
Next in thread: Ric Van Dyke: "RE: Moving LOB's from tablespace to tablespace"
Reply: Ric Van Dyke: "RE: Moving LOB's from tablespace to tablespace"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message