PARENT TABLE FOR AN LOB SEGMENT

[Former Member]

Hi folks,

Could  anyone  suggest on how to identify Parent tables for an LOB segments.

Regards,

Sharma TVK

[stefan_koehler · Accepted solution]

Hi Sharma,

just query the database view DBA_LOBS (from SQL*Plus or DBACOCKPIT).

Oracle Documentation: http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_1130.htm#i1581211

Something like this:

SQL> SELECT TABLE_NAME, COLUMN_NAME FROM DBA_LOBS WHERE SEGMENT_NAME = '<LOBSEG_NAME>';

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

Thanks for the information.

Regards,

Sharma TVK