http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fdba_indexes 2026-05-25T12:17:19Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_indexes&diff=3967&oldid=prev 2010-05-26T13:45:46Z

<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://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_indexes&diff=3968&oldid=prev 2010-05-26T10:08:14Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== Search for indexes created by anyone other than the table owner.==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; select<br /> 2 Owner, /*Owner of the index*/<br /> 3 Index_Name, /*Name of the index*/<br /> 4 Table_Owner, /*Owner of the table*/<br /> 5 Table_Name /*Name of the indexed table*/<br /> 6 from DBA_INDEXES<br /> 7 where Owner != Table_Owner and rownum &lt; 10;<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Union dba_indexes and dba_tables==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; select<br /> 2 Owner,<br /> 3 Tablespace_Name,<br /> 4 COUNT(*)||&quot; tables&quot; Objects<br /> 5 from DBA_TABLES<br /> 6 group by<br /> 7 Owner,<br /> 8 Tablespace_Name<br /> 9 union<br /> 10 select<br /> 11 Owner,<br /> 12 Tablespace_Name,<br /> 13 COUNT(*)||&quot; indexes&quot; Objects<br /> 14 from dba_indexes<br /> 15 group by<br /> 16 Owner,<br /> 17 Tablespace_Name;<br /> <br /> OWNER TABLESPACE_NAME OBJECTS<br /> ------------------------------ ------------------------------ ------------------------------------------------<br /> CTXSYS SYSAUX 26 tables<br /> CTXSYS SYSAUX 47 indexes<br /> CTXSYS 11 tables<br /> DBSNMP SYSAUX 17 tables<br /> DBSNMP SYSAUX 8 indexes<br /> DBSNMP 2 indexes<br /> DBSNMP 4 tables<br /> DEFINER SYSTEM 1 indexes<br /> DEFINER 1 tables<br /> FLOWS_020100 SYSAUX 160 tables<br /> FLOWS_020100 SYSAUX 422 indexes<br /> FLOWS_020100 4 tables<br /> FLOWS_FILES SYSAUX 1 tables<br /> FLOWS_FILES SYSAUX 5 indexes<br /> HR USERS 19 indexes<br /> HR USERS 6 tables<br /> HR 1 tables<br /> INV10 SYSTEM 1 indexes<br /> INV10 1 tables<br /> INV11 SYSTEM 1 indexes<br /> INV11 1 tables<br /> INV12 SYSTEM 1 indexes<br /> INV12 1 tables<br /> INV13 SYSTEM 1 indexes<br /> INV13 1 tables<br /> INV14 SYSTEM 1 indexes<br /> INV14 1 tables<br /> INV15 SYSTEM 1 indexes<br /> INV15 1 tables<br /> INV16 SYSTEM 1 indexes<br /> INV16 1 tables<br /> INV17 SYSTEM 1 indexes<br /> INV17 1 tables<br /> INV18 SYSTEM 1 indexes<br /> INV18 1 tables<br /> INV19 SYSTEM 1 indexes<br /> INV19 1 tables<br /> INV20 SYSTEM 1 indexes<br /> INV20 1 tables<br /> sqle SYSTEM 12 indexes<br /> sqle SYSTEM 14 tables<br /> sqle 3 indexes<br /> sqle 9 tables<br /> MDSYS SYSTEM 30 tables<br /> MDSYS SYSTEM 51 indexes<br /> MDSYS 3 indexes<br /> MDSYS 7 tables<br /> OUTLN SYSTEM 3 tables<br /> OUTLN SYSTEM 4 indexes<br /> SYS SYSAUX 175 tables<br /> SYS SYSAUX 247 indexes<br /> SYS SYSTEM 402 tables<br /> SYS SYSTEM 513 indexes<br /> SYS 28 indexes<br /> SYS 92 tables<br /> SYSTEM SYSAUX 21 indexes<br /> SYSTEM SYSAUX 22 tables<br /> SYSTEM SYSTEM 145 indexes<br /> SYSTEM SYSTEM 85 tables<br /> SYSTEM 31 tables<br /> SYSTEM 36 indexes<br /> TSMSYS SYSAUX 1 tables<br /> TSMSYS SYSAUX 2 indexes<br /> XDB SYSAUX 11 tables<br /> XDB SYSAUX 384 indexes<br /> XDB 1 indexes<br /> <br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;</div>

Admin