ALL_LIBRARIES

ALL_LIBRARIES describes all the libraries that are accessible to the current user.

Related Views

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

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the library
`LIBRARY_NAME`	`VARCHAR2(30)`	`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 (`YES`) or not (`NO`)
`STATUS`	`VARCHAR2(7)`		Status of the library (`VALID`, `INVALID`, or `N/A`)