Relocating LOB segment

From: Hameed, Amir <>
Date: Fri, 6 Feb 2015 03:26:30 +0000
Message-ID: <>

Hi folks,
We need to relocate a ~300GB LOB segment from one tablespace to another tablespace. The MOVE command, when ran against copy of production, took somewhere around 20 hours to relocate the LOB. When I ran the ALTER TABLE.... Command with parallel option and traced it with 10046, it seems that under the hood the operation was getting serialized. I was wondering if anyone has experience with relocating large LOB segments and what approach was taken to minimize the down time. Any feedback will be appreciated.


Received on Fri Feb 06 2015 - 04:26:30 CET

Original text of this message