SQL>
SQL> set verify off
SQL> set linesize 80
SQL>
SQL> column table_column format a45 heading "Table and Column of LOB"
SQL> column lob_name format a25 heading "LOB Name"
SQL> column in_row format a6 heading "In?"
SQL>
SQL> select table_name || "." || column_name table_column,
2 segment_name lob_name, in_row
3 from dba_lobs
4 where rownum < 50;
Table and Column of LOB LOB Name In?
--------------------------------------------- ------------------------- ------
VIEWCON$.CON_TEXT SYS_LOB0000000207C00005$$ YES
SNAP$.REL_QUERY SYS_LOB0000000212C00048$$ YES
SNAP$.ALIAS_TXT SYS_LOB0000000212C00049$$ YES
TABPART$.BHIBOUNDVAL SYS_LOB0000000266C00026$$ YES
INDPART$.BHIBOUNDVAL SYS_LOB0000000271C00028$$ YES
TABSUBPART$.BHIBOUNDVAL SYS_LOB0000000278C00026$$ YES
INDSUBPART$.BHIBOUNDVAL SYS_LOB0000000283C00026$$ YES
TABCOMPART$.BHIBOUNDVAL SYS_LOB0000000288C00034$$ YES
INDCOMPART$.BHIBOUNDVAL SYS_LOB0000000293C00034$$ YES
DEFSUBPART$.BHIBOUNDVAL SYS_LOB0000000305C00008$$ YES
KOTTD$.SYS_NC_ROWINFO$ SYS_LOB0000000335C00002$$ YES
KOTTB$.SYS_NC_ROWINFO$ SYS_LOB0000000340C00002$$ YES
KOTAD$.SYS_NC_ROWINFO$ SYS_LOB0000000345C00002$$ YES
KOTMD$.SYS_NC_ROWINFO$ SYS_LOB0000000350C00002$$ YES
KOTTBX$.SYS_NC_ROWINFO$ SYS_LOB0000000355C00002$$ YES
KOTADX$.SYS_NC_ROWINFO$ SYS_LOB0000000360C00002$$ YES
SUM$.SRC_STMT SYS_LOB0000000393C00030$$ YES
SUM$.DEST_STMT SYS_LOB0000000393C00031$$ YES
OL$HINTS.HINT_STRING SYS_LOB0000000453C00021$$ YES
SQL$TEXT.SQL_TEXT SYS_LOB0000000462C00002$$ YES
METASTYLESHEET.STYLESHEET SYS_LOB0000000493C00003$$ YES
EXTERNAL_TAB$.PARAM_CLOB SYS_LOB0000000507C00007$$ YES
EXTERNAL_TAB$.PARAM_BLOB SYS_LOB0000000507C00008$$ YES
JIREFRESHSQL$.SQLTEXT SYS_LOB0000000544C00003$$ YES
AUD$.SQLBIND SYS_LOB0000000558C00040$$ YES
AUD$.SQLTEXT SYS_LOB0000000558C00041$$ YES
FGA_LOG$.LSQLTEXT SYS_LOB0000000564C00013$$ YES
FGA_LOG$.LSQLBIND SYS_LOB0000000564C00028$$ YES
PS$.GELOB SYS_LOB0000000580C00008$$ NO
AW_OBJ$.OBJDEF SYS_LOB0000000586C00007$$ YES
AW_OBJ$.OBJVALUE SYS_LOB0000000586C00008$$ YES
AW_OBJ$.ruPCODE SYS_LOB0000000586C00009$$ YES
AW_PROP$.PROPVAL SYS_LOB0000000594C00007$$ YES
STREAMS$_DEF_PROC.CLOB_VALUE SYS_LOB0000000630C00013$$ YES
STREAMS$_DEF_PROC.BLOB_VALUE SYS_LOB0000000630C00014$$ YES
STREAMS$_DEF_PROC.NCLOB_VALUE SYS_LOB0000000630C00015$$ YES
REDEF_DEP_ERROR$.DDL_TXT SYS_LOB0000000723C00007$$ YES
NCOMP_DLL$.DLL NATIVE_COMP_SHARED_OBJECT YES
S
EXPIMP_TTS_CT$.XMLINFO SYS_LOB0000000734C00003$$ YES
RECO_SCRIPT$.CONTEXT SYS_LOB0000000807C00007$$ YES
RECO_SCRIPT_BLOCK$.FORWARD_BLOCK SYS_LOB0000000813C00003$$ YES
RECO_SCRIPT_BLOCK$.UNDO_BLOCK SYS_LOB0000000813C00005$$ YES
RECO_SCRIPT_BLOCK$.STATE_BLOCK SYS_LOB0000000813C00007$$ YES
RECO_SCRIPT_BLOCK$.CONTEXT SYS_LOB0000000813C00009$$ YES
WRI$_ADV_OBJECTS.ATTR4 SYS_LOB0000003690C00007$$ YES
WRI$_ADV_OBJECTS.OTHER SYS_LOB0000003690C00009$$ YES
WRI$_ADV_ACTIONS.ATTR5 SYS_LOB0000003700C00010$$ YES
WRI$_ADV_ACTIONS.ATTR6 SYS_LOB0000003700C00011$$ YES
WRI$_ADV_RATIONALE.ATTR5 SYS_LOB0000003706C00013$$ YES
49 rows selected.
SQL>
SQL> --