Query that shows 'BLOBs stored inline'

Question

I need to produce a query that shows a table(table_name, column_name) of where BLOBs are stored inline from user_tables. Any help would be much appreciated.

Nick Krasnov · Accepted Answer · 2013-08-13 10:53:08Z

2

To determine whether a LOB column is stored in-line or out-of-line, you need to take a look at the IN_ROW column value of user_lobs view (or [dba] [all] _lobs views depending on the privileges granted): YES - inline, NO - out-of-line:

For instance:

select t.table_name
     , t.column_name
     , t.in_row
  from user_lobs t
where table_name = 'BLOB_TABLE'

Result:

Table Name   Column Name In Row 
--------------------------------
BLOB_TABLE   COL1        YES 
BLOB_TABLE   COL2        YES 
BLOB_TABLE   COL3        YES

answered Aug 13, 2013 at 10:53

Nick Krasnov

27.3k6 gold badges66 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query that shows 'BLOBs stored inline'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related