Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Select segment_name, segment_type from user_segments

SQL> SQL> select segment_name, segment_type from user_segments; SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ DEPT$AUDIT TABLE P1 TABLE MYSTATS TABLE IT TABLE DEMO TABLE CUST_NO_KEY_TABLE TABLE SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ PASSWORD_AUDIT TABLE CUSTLOG TABLE EMP_DELTAS TABLE INVENTORY_TBL TABLE P TABLE MYTABLE1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ TABLE SYSTEM_STATS TABLE HD_CLUSTER CLUSTER SYS_C005096 INDEX MYSTATS INDEX SYS_C005376 INDEX SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ SYS_C005536 INDEX SYS_C005404 INDEX SYS_IOT_TOP_16135 INDEX SYS_C006948 INDEX HD_CLUSTER_INDEX INDEX SYS_C0010267 INDEX SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ SYS_C009993 INDEX SYSTEM_STATS INDEX 25 rows selected. SQL> SQL> create table t ( x int primary key, y clob, z blob ); Table created. SQL> SQL> select segment_name, segment_type from user_segments; SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ DEPT$AUDIT TABLE P1 TABLE MYSTATS TABLE IT TABLE DEMO TABLE CUST_NO_KEY_TABLE TABLE SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ PASSWORD_AUDIT TABLE CUSTLOG TABLE EMP_DELTAS TABLE INVENTORY_TBL TABLE P TABLE MYTABLE1 SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ TABLE T TABLE SYSTEM_STATS TABLE HD_CLUSTER CLUSTER SYS_C005096 INDEX MYSTATS INDEX SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ SYS_C005376 INDEX SYS_C005536 INDEX SYS_C005404 INDEX SYS_IOT_TOP_16135 INDEX SYS_C006948 INDEX HD_CLUSTER_INDEX INDEX SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ SYS_C0010267 INDEX SYS_C009993 INDEX SYS_IL0000021357C00002$$ LOBINDEX SYS_IL0000021357C00003$$ LOBINDEX SYS_C0010294 INDEX SYSTEM_STATS SEGMENT_NAME -------------------------------------------------------------------------------- SEGMENT_TYPE ------------------ INDEX SYS_LOB0000021357C00002$$ LOBSEGMENT SYS_LOB0000021357C00003$$ LOBSEGMENT 31 rows selected. SQL> SQL> drop table t; Table dropped. SQL>