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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2009
Added on Apr 15 2009
3 comments
38,921 views