http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fuser_segments Oracle PL/SQL Tutorial/System Tables Data Dictionary/user segments - История изменений 2026-04-06T00:56:05Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/user_segments&diff=3949&oldid=prev в 13:45, 26 мая 2010 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://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/user_segments&diff=3950&oldid=prev Admin: 1 версия 2010-05-26T10:08:11Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Get invalid table objects==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt; column object_name format a30<br /> SQL&gt; column tablespace_name format a30<br /> SQL&gt; column object_type format a12<br /> SQL&gt; column status format a1<br /> SQL&gt; column status format a10<br /> SQL&gt; break on object_type skip 1<br /> SQL&gt;<br /> SQL&gt; select object_type, object_name,<br /> 2 decode(status,&quot;INVALID&quot;,&quot;*&quot;,&quot;&quot;) status,<br /> 3 tablespace_name<br /> 4 from user_objects a, user_segments b<br /> 5 where a.object_name = b.segment_name (+)<br /> 6 and a.object_type = b.segment_type (+)<br /> 7 and rownum &lt; 50<br /> 8 order by object_type, object_name<br /> 9 /<br /> <br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> FUNCTION COMPUTE_DISCOUNTS<br /> DELETEEMPLOYEE *<br /> EXITFUNC<br /> F_GETDIFF *<br /> GETAREA<br /> INDEX BIN$fKX+qNArQt+8GLZvNQJlrQ==$0 SYSTEM<br /> <br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> PACKAGE PKG *<br /> PKG_TEST1<br /> PACKAGE BODY PKG_TEST1<br /> PROCEDURE ADD_NEW_EMPLOYEE *<br /> clear columns;<br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> PROCEDURE AUTHORS_SEL *<br /> AUTHOR_FIRST_NAME_UPD *<br /> AUTHOR_SEL *<br /> BIND_TEST *<br /> CHANGEPRICE<br /> COMPILE_WARNING *<br /> DELETEMYEMPLOYEE *<br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> PROCEDURE EMPLOYEE_COUNT *<br /> EMP_CHANGE_S *<br /> HELLO<br /> HELLOFLE *<br /> HIKE_PRICES<br /> INSERT_NUMBERS *<br /> MEASURE_USAGE *<br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> PROCEDURE MULTIPLE_CURSORS_PROC<br /> MYPROCEDURE *<br /> MY_FIRST_PROC<br /> NAMED_BLOCK *<br /> P<br /> P_HELLO<br /> P_HELLOTO<br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> TABLE BIN$dgfyftgCSZSBnu0LqVJzrQ==$0 USERS<br /> BIN$zbJqSAxnQA2up7MHjGauHw==$0 USERS<br /> EMPLOYEE_TAB<br /> EMP_DEPT SYSTEM<br /> PEOPLE SYSTEM<br /> <br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> TRIGGER EMP_NAME_CHANGE *<br /> LOG_SHUTDOWN *<br /> LOG_STARTUP *<br /> TYPE ADDRESSTYPE<br /> ADDRESS_OBJ<br /> AOBJ<br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> TYPE EMPLOYEETYPE<br /> PERSONTYPE<br /> PRODUCTTYPE<br /> TYPE BODY AOBJ<br /> EMPLOYEETYPE<br /> <br /> OBJECT_TYPE OBJECT_NAME STATUS TABLESPACE_NAME<br /> ------------ ------------------------------ ---------- ------------------------------<br /> VIEW EMP_DATA *<br /> NEWYORKEMP *<br /> <br /> 49 rows selected.<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == select * from DBA_SEGMENTS where Segment_Type = &quot;ROLLBACK&quot;==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; select * from DBA_SEGMENTS<br /> 2 where Segment_Type = &quot;ROLLBACK&quot;;<br /> <br /> OWNER SEGMENT_NAME<br /> ------------ ---------------------------------------------------------------------------------<br /> PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME HEADER_FILE HEADER_BLOCK<br /> ------------------------------ ------------------ ------------------------------ ----------- ------------<br /> BYTES BLOCKS EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS<br /> ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ----------<br /> FREELIST_GROUPS RELATIVE_FNO BUFFER_<br /> --------------- ------------ -------<br /> SYS SYSTEM<br /> ROLLBACK SYSTEM 1 9<br /> 393216 48 6 114688 1048576 1 32765 0 1<br /> 1 1 DEFAULT<br /> <br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == select segment_name, segment_type from user_segments==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; select segment_name, segment_type from user_segments;<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> DEPT$AUDIT<br /> TABLE<br /> P1<br /> TABLE<br /> MYSTATS<br /> TABLE<br /> IT<br /> TABLE<br /> DEMO<br /> TABLE<br /> CUST_NO_KEY_TABLE<br /> TABLE<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> PASSWORD_AUDIT<br /> TABLE<br /> CUSTLOG<br /> TABLE<br /> EMP_DELTAS<br /> TABLE<br /> INVENTORY_TBL<br /> TABLE<br /> P<br /> TABLE<br /> MYTABLE1<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> TABLE<br /> SYSTEM_STATS<br /> TABLE<br /> HD_CLUSTER<br /> CLUSTER<br /> SYS_C005096<br /> INDEX<br /> MYSTATS<br /> INDEX<br /> SYS_C005376<br /> INDEX<br /> <br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> SYS_C005536<br /> INDEX<br /> SYS_C005404<br /> INDEX<br /> SYS_IOT_TOP_16135<br /> INDEX<br /> SYS_C006948<br /> INDEX<br /> HD_CLUSTER_INDEX<br /> INDEX<br /> SYS_C0010267<br /> INDEX<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> SYS_C009993<br /> INDEX<br /> SYSTEM_STATS<br /> INDEX<br /> <br /> 25 rows selected.<br /> SQL&gt;<br /> SQL&gt; create table t ( x int primary key, y clob, z blob );<br /> Table created.<br /> SQL&gt;<br /> SQL&gt; select segment_name, segment_type from user_segments;<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> DEPT$AUDIT<br /> TABLE<br /> P1<br /> TABLE<br /> MYSTATS<br /> TABLE<br /> IT<br /> TABLE<br /> DEMO<br /> TABLE<br /> CUST_NO_KEY_TABLE<br /> TABLE<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> PASSWORD_AUDIT<br /> TABLE<br /> CUSTLOG<br /> TABLE<br /> EMP_DELTAS<br /> TABLE<br /> INVENTORY_TBL<br /> TABLE<br /> P<br /> TABLE<br /> MYTABLE1<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> TABLE<br /> T<br /> TABLE<br /> SYSTEM_STATS<br /> TABLE<br /> HD_CLUSTER<br /> CLUSTER<br /> SYS_C005096<br /> INDEX<br /> MYSTATS<br /> INDEX<br /> <br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> SYS_C005376<br /> INDEX<br /> SYS_C005536<br /> INDEX<br /> SYS_C005404<br /> INDEX<br /> SYS_IOT_TOP_16135<br /> INDEX<br /> SYS_C006948<br /> INDEX<br /> HD_CLUSTER_INDEX<br /> INDEX<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> SYS_C0010267<br /> INDEX<br /> SYS_C009993<br /> INDEX<br /> SYS_IL0000021357C00002$$<br /> LOBINDEX<br /> SYS_IL0000021357C00003$$<br /> LOBINDEX<br /> SYS_C0010294<br /> INDEX<br /> SYSTEM_STATS<br /> SEGMENT_NAME<br /> --------------------------------------------------------------------------------<br /> SEGMENT_TYPE<br /> ------------------<br /> INDEX<br /> SYS_LOB0000021357C00002$$<br /> LOBSEGMENT<br /> SYS_LOB0000021357C00003$$<br /> LOBSEGMENT<br /> <br /> 31 rows selected.<br /> SQL&gt;<br /> SQL&gt; drop table t;<br /> Table dropped.<br /> SQL&gt;&lt;/source&gt;</div> Admin