Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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