RE: Help with moving lobsegments and lobindexes....
Date: Fri, 25 Jan 2008 16:36:02 -0500
Just as an extra 2c: there is a nasty bug #4748597 "Moving a LOB in a partitioned table fails to update IND$":
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.
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.
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
Subject: Re: Help with moving lobsegments and lobindexes....
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.
http://www.freelists.org/webpage/oracle-l Received on Fri Jan 25 2008 - 15:36:02 CST