本站中文解释
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_LIBRARIESdescribes all libraries in the database. -
USER_LIBRARIESdescribes the libraries owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the library |
|
|
|
|
Library name |
|
|
|
Operating system file specification associated with the library |
|
|
|
|
Indicates whether the library is dynamically loadable ( |
|
|
|
|
Status of the library:
|
|
|
|
|
Agent of the library |
|
|
|
|
Leaf filename of the library |
|
|
|
|
The ID of the container where the data originates. Possible values include:
|
See Also:
-
“DBA_LIBRARIES”
-
“USER_LIBRARIES”