Oracle教程 2023-02-23

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

ALL_LIBARIES视图主要显示拥有用户使用特权的库和库之间的关系，包括库的名称，所属用户，库是否可读/可写，库所属的正式组等。ALL_LIBRARIES视图是为了查看当前用户可用的库，也可以理解成用来存储调用存储库的父库的库的一个表。

使用ALL_LIBRARIES视图，可以从Data Dictionary查找库的字典描述及其对象的信息，允许管理者审查、分析和改善数据字典中现有库的状态。

例如，可以使用下面的查询查询当前用户可被查看的所有库:

SELECT library_name FROM all_libraries;

ALL_LIBRARIES describes the libraries accessible to the current user.

Related Views

DBA_LIBRARIES describes all libraries in the database.
USER_LIBRARIES describes the libraries owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the library
`LIBRARY_NAME`	`VARCHAR2(128)`	`NOT NULL`	Library name
`FILE_SPEC`	`VARCHAR2(2000)`		Operating system file specification associated with the library
`DYNAMIC`	`VARCHAR2(1)`		Indicates whether the library is dynamically loadable (`Y`) or not (`N`)
`STATUS`	`VARCHAR2(7)`		Status of the library: `N/A` `VALID` `INVALID`
`AGENT`	`VARCHAR2(128)`		Agent of the library
`LEAF_FILENAME`	`VARCHAR2(2000)`		Leaf filename of the library
`ORIGIN_CON_ID`	`VARCHAR2(256)`		The ID of the container where the data originates. Possible values include: `0`: This value is used for rows in non-CDBs. This value is not used for CDBs. n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)