Query dba_lobs table : dba_lobs « System Tables Views « Oracle PL / SQL






Query dba_lobs table

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

 








Related examples in the same category