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 ) |