ALL_LIBRARIES describes all the libraries that are accessible to the current user.
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) |