tag:blogger.com,1999:blog-20612393.post7200334486010504425..comments2023-09-29T21:26:11.876+07:00Comments on Surachart Opun's Blog: Move LOBSEGMENT to different tablespaceSurachart Opunhttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-20612393.post-64023200668772925472012-01-09T09:24:24.662+07:002012-01-09T09:24:24.662+07:00Thx a lot. Using your guide,I've generated scr...Thx a lot. Using your guide,I've generated script to move all lobsegment to an other tablespace with this statement :<br /><br />select 'alter table '||owner||'.'||table_name||' move lob ('||column_name||') store as '||segment_name||' (tablespace NEW_TBS);'<br />from all_lobs<br />where segment_name in (select segment_name from dba_segments where OLINEXhttps://www.blogger.com/profile/17240145155556558378noreply@blogger.com