Moving LOB Faster to another tablespace
LyxxApr 6 2010 — edited Apr 6 2010DB:10.2.0.4 ( Sun Solaris 8 )
Hi -
I have to move one table with LOB segment ( 300 GB ) to another tablespace which is taking 18+ hours alone for this table. ( there are other lobs tables as well)
Options I tried
1- tried expdp/impdp with parallell option but did not work as it seems import is working sequentially
2- Insert /+APPEND*/ but still it taking same time as LOB index is there so it can not bypass redo
3- CTAS - same as above
4- MOVE lob store as ... same speed.
Did anyone face similar kind of problem.. any tip/suggestion to improve the performance ?
Thanks-
Lyxx