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)		Whether the library is dynamically loadable (YES | NO)
  STATUS	VARCHAR2(7)		Status of the library (VALID, INVALID, or N/A)