Query dba_lobs table : dba_lobs « System Tables Views


 

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$.COMPCODE                              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> --
Query dba_lobs table : dba_lobs « System Tables Views « Oracle PL / SQL
