Finding which table a LOB belongs to
The FlazApr 15 2009 — edited Apr 15 2009Hello
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