LOB Segment Maintenance

Hi,

This is Tushar. I planning to move all the objects into the same tablespace for 
re-org purpose. My DB contains some LOB segments, and I already had an bad 
experience while moving them to other tablespace.
Could someone please suggest the fastest method to move LOB segments?

Also how can I find the objects those are at the end of the tablespace. So if I 
bring them to the begining of the tablespace I can start reducing my datafiles.

> This is Tushar. I planning to move all the objects into the same tablespace 
> for re-org purpose. My DB contains some LOB segments, and I already had an 
> bad experience while moving them to other tablespace.
> Could someone please suggest the fastest method to move LOB segments?

Can you elaborate on the bad experience you had?  Was it performance related?


> Also how can I find the objects those are at the end of the tablespace. So 
> if I bring them to the begining of the tablespace I can start reducing my 
> datafiles.

You can join results of dba_free_space and dba_extents in a union ordering by 
file_id, block_id.  For an example go to:

   DBAToolZ - Scripts ( Tablespace )

then check out s_tabsp_detail.sql

HTH,
- Vitaliy