Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Moving LOB Faster to another tablespace

LyxxApr 6 2010 — edited Apr 6 2010
DB: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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2010
Added on Apr 6 2010
11 comments
5,614 views