http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fdba_lobs 2026-04-30T17:04:15Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_lobs&diff=2146&oldid=prev 2010-05-26T13:45:19Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_lobs&diff=2147&oldid=prev 2010-05-26T10:01:04Z

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

Admin