select segment_name, segment_type from user_segments : user_segments « System Tables Views « Oracle PL / SQL






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>

   
    
    
  








Related examples in the same category

1.Getting a Database List
2.Check if an object is valid by querying user_segments table