ALL_LIBRARIES
ALL_LIBRARIES describes the libraries accessible to the current user.
Related Views
-
DBA_LIBRARIESdescribes all libraries in the database. -
USER_LIBRARIESdescribes the libraries owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the library |
LIBRARY_NAME |
VARCHAR2(128) |
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:
|
|
AGENT |
VARCHAR2(128) |
Agent of the library | |
LEAF_FILENAME |
VARCHAR2(2000) |
Leaf filename of the library | |
ORIGIN_CON_ID |
VARCHAR2(256) |
The ID of the container where the data originates. Possible values include:
|
See Also: