Move LOB Segments To A New Tablespace

Step1:Create a dynamic SQL Statments to Move LOB Segements
spool d:\move_lob.sql
SELECT 'alter table '
|| owner
|| '.'
|| table_name
|| ' move lob ('
|| column_name
|| ')'
|| 'store as (tablespace users_idx_tbs);'
FROM dba_lobs
WHERE segment_name IN (
SELECT segment_name
FROM dba_segments
WHERE tablespace_name = 'USERS'
AND owner = 'AUTO_PORTAL'
AND segment_type = 'LOBSEGMENT');
Spool off

Step2:From SQLPLUS
Conn SYSTEM/SYSTEM_PASSWORD
SQL>@d:\move_lob.sql