user_segments和user_objects

SQL> col object_name format a30;

SQL> col segment_type format a30;

SQL> col segment_name format a30;

SQL> col object_type format a30;

SQL> select segment_name,segment_type from user_segments;

SEGMENT_NAME       SEGMENT_TYPE

------------------------------ ------------------------------

DEPT       TABLE

EMP       TABLE

SALGRADE       TABLE

STUDENT       TABLE

CDPT       TABLE

T_USER       TABLE

PK_DEPT       INDEX

PK_EMP       INDEX

SYS_C0011233       INDEX

PK_ID       INDEX

已选择10行。

SQL> select object_name,object_type from user_objects;

OBJECT_NAME       OBJECT_TYPE

------------------------------ ------------------------------

PK_DEPT       INDEX

DEPT       TABLE

EMP       TABLE

PK_EMP       INDEX

BONUS       TABLE

SALGRADE       TABLE

T_USER       TABLE

STUDENT       TABLE

SYS_C0011233       INDEX

CDPT       TABLE

SEQEMP       SEQUENCE

OBJECT_NAME       OBJECT_TYPE

------------------------------ ------------------------------

PK_ID       INDEX

已选择12行。