Oracle教程 2023-03-23

Oracle 视图 ALL_SECONDARY_OBJECTS 官方解释，作用，如何使用详细说明

Oracle视图ALL_SECONDARY_OBJECTS是系统视图，它可以提供当前拥有者其他用户创建的复合对象、索引、基本表、视图等信息。

用途：主要用于获取当前拥有者以外的其他用户创建的SQL语句段，视图等其他对象的信息。

使用方法：在Oracle中，可以使用下面的select语句来检索ALL_SECONDARY_OBJECTS视图：

SELECT *
FROM all_secondary_objects;

ALL_SECONDARY_OBJECTS provides information about secondary objects associated with domain indexes accessible to the user.

This view is only relevant for domain indexes. And currently, the secondary objects can only be tables.

Related Views

DBA_SECONDARY_OBJECTS provides information about all secondary objects that are associated with domain indexes in the database.
USER_SECONDARY_OBJECTS provides information about secondary objects associated with domain indexes owned by the current user.

Column	Datatype	NULL	Description
`INDEX_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the domain index
`INDEX_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the domain index
`SECONDARY_OBJECT_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the secondary object created by the domain index
`SECONDARY_OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the secondary object created by the domain index
`SECONDARY_OBJDATA_TYPE`	`VARCHAR2(20)`		Type of the secondary object created by the domain index