【视图】oracle 数据字典视图之 DBA_OBJECTS / ALL_OBJECTS / USER_OBJECTS（OBJ）

1. DBA_OBJECTS / ALL_OBJECTS / USER_OBJECTS（OBJ）视图是非常非常常用的数据视图，可以获得数据库中任意的对象
sys@ora10g> desc dba_objects;
 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------------------
 OWNER                                              VARCHAR2(30)
 OBJECT_NAME                                        VARCHAR2(128)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_ID                                          NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                        VARCHAR2(19)
 CREATED                                            DATE
 LAST_DDL_TIME                                      DATE
 TIMESTAMP                                          VARCHAR2(19)
 STATUS                                             VARCHAR2(7)
 TEMPORARY                                          VARCHAR2(1)
 GENERATED                                          VARCHAR2(1)
 SECONDARY                                          VARCHAR2(1)

sys@ora10g> select count(*) from dba_objects;

  COUNT(*)
----------
     11441

sys@ora10g> select count(*) from obj;

  COUNT(*)
----------
      6751

sys@ora10g> select count(*) from user_objects;

  COUNT(*)
----------
      6751

sys@ora10g> select count(*) from all_objects;

  COUNT(*)
----------
     11376

sys@ora10g> conn sec/sec