../E40402-16.epub /> ../E40402-16.mobi />

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(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 (Y) or not (N)
STATUS VARCHAR2(7)   Status of the library:
  • N/A

  • VALID

  • INVALID