Find LOB object parent table

Some times you find that there are some BIG lob segments and you don’t know which table they belong to…

Here’s the solution:

SELECT TABLE_NAME, column_name
FROM   user_lobs
WHERE  segment_name = (SELECT object_name
                       FROM   user_objects
                       WHERE  object_name = UPPER('&object_name')
                       AND    object_type = 'LOB');

in MacLochlainns Weblog

I hope it was useful!!!

  1. Hi, thanks for sharing. I’m wondering if it’s OK to copy some of the text in my site?

Leave a Comment

NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Optimization WordPress Plugins & Solutions by W3 EDGE