Oracle PL/SQL/System Tables Views/dba lobs

Query dba_lobs table

   <source lang="sql">

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> --

</source>