• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

how do I find what table a lob relates to?

Thanks?

I need to identify tables for the lob segments so I can see where the space is disappearing to.

:-)

G
0
gswitz
Asked:
gswitz
1 Solution
 
slightwv (䄆 Netminder) Commented:
The user_lobs (or all_lobs/dba_lobs ) view has the table_name for the lob segment_name.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now