RE: Help with moving lobsegments and lobindexes....

Just as an extra 2c: there is a nasty bug #4748597 "Moving a LOB in a partitioned table fails to update IND$":

Description:
Moving a LOB in a partitioned table to another tablespace fails to update the dictionary IND$ table for the LOB index. This can cause ORA-22864 when attempting to drop the old tablespace.

Note:
The fix for this bug will not correct existing dictionary corruptions due to this problem - it only stops the problem happening in the first place.

I recently hit it (one of our clients is still on 10.2.0.2) - and had to drop/create/reload the attribute.  

Regards,
Michael Rosenblum
Dulcian Inc

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bradd Piontek
Sent: Friday, January 25, 2008 1:46 PM
To: Mark.Bobak_at_proquest.com
Cc: oracle-l_at_freelists.org
Subject: Re: Help with moving lobsegments and lobindexes....

Mark,

   take a peak at DBA_LOBS for the mapping between table/columns and the log segment and index names.

As to you syntax, it looks correct to me and is how I've moved lob segments in the past.
--Bradd Piontek

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 25 2008 - 15:36:02 CST