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!

Finding which table a LOB belongs to

The FlazApr 15 2009 — edited Apr 15 2009

Hello

I have a load of lob segments which I need to move to a different tablespace. I know the syntax to do this but am struggling to find out the tablename that the lob related to.

I can look through dba_extents, dba_segments and find the lobs but can't link them to a table in order to run the command

eg select segment_name,segment_type,tablespace_name,owner from dba_extents where tablespace_name='USERS' and owner like 'xxxx'

I am probably missing something painfully obvious

Please help

Sandy

This post has been answered by 26741 on Apr 15 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2009

Added on Apr 15 2009

#general-database-discussions

3 comments

39,139 views