哪个视图能获取有关所有数据字典视图的所有信息？

它被称为字典。

看起来像这样：

SQL> desc dictionary
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLE_NAME                                         VARCHAR2(30)
 COMMENTS                                           VARCHAR2(4000)

您可以像这样查询它（例如，搜索谈论“约束”的内容）：

SQL> select * From dictionary where lower(comments) like '%constraint%';

TABLE_NAME                COMMENTS
------------------------- --------------------------------------------------
ALL_CONSTRAINTS           Constraint definitions on accessible tables
ALL_CONS_COLUMNS          Information about accessible columns in constraint
                           definitions

USER_CONSTRAINTS          Constraint definitions on user's own tables
USER_CONS_COLUMNS         Information about accessible columns in constraint
                           definitions


SQL>